The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL 4.1

Discussion in 'General Discussion' started by hyborian, Sep 23, 2004.

  1. hyborian

    hyborian Registered

    Joined:
    Mar 10, 2004
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    I'm running a cpanel install with mysql 4.0.20, I click update server software, and it says mysql is up to date. Alas, I need 4.1 for subqueries. Any help here?
     
  2. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    check with C-panel itself if they have started to suppport mysql 4.1.
     
  3. cPanelBilly

    cPanelBilly Guest

    MySQL 4.1 is not yet Stable. It will not be released to the cPanel community until it is
     
  4. qupanuaq

    qupanuaq Registered

    Joined:
    Jul 25, 2004
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Mysql 4.1 is now GAMMA. Any idea when it'll go stable?
     
  5. Sinewy

    Sinewy Well-Known Member

    Joined:
    May 15, 2004
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Sydney, Australia
    cPanel Access Level:
    DataCenter Provider
    i doubt it'll be so soon.
     
  6. StevenC

    StevenC Well-Known Member

    Joined:
    Jan 1, 2004
    Messages:
    254
    Likes Received:
    0
    Trophy Points:
    16
    We have a server running it with no problems at all.
     
  7. hyborian

    hyborian Registered

    Joined:
    Mar 10, 2004
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    got a howto

    you got a howto for a cpanel friendly way to upgrade it?
     
  8. carluk

    carluk Well-Known Member

    Joined:
    Sep 2, 2003
    Messages:
    162
    Likes Received:
    0
    Trophy Points:
    16
    Have you tried installing the RPM?
     
  9. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,381
    Likes Received:
    23
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    We have one server running 4.1 we installed from the RPM. We did notice that there were some problems with the CPanel version of phpMyAdmin with 4.1. Upgrading phpMyAdmin seems to fix it though.
     
  10. barwin

    barwin Active Member

    Joined:
    Jan 5, 2004
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Manhattan
    MySQL 4.1 stable now?

    From MySQL's download page, it appears that the 4.1 branch is now listed as an official release.
     
  11. barwin

    barwin Active Member

    Joined:
    Jan 5, 2004
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Manhattan
  12. Elikster

    Elikster Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    119
    Likes Received:
    1
    Trophy Points:
    18
    Yup...

    But...it is first release and frankly, it is not to be used for production servers unless you willing to take the heat from users on some problems that will eventually crop up that is not noticable at first but will be.

    I usually upgrade when it is officially one to 3 releases later after initial release like I am doing with PHP5, which I haven't upgraded yet due to some instability and incompabilities issues that is raised for this.
     
  13. barwin

    barwin Active Member

    Joined:
    Jan 5, 2004
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Manhattan
    in general that's true

    I agree that with many products, and especially PHP, you should wait till a few releases have come out.

    With MySQL, on the other hand, I feel like they purposefully kept 4.1 in beta/gamma stage for such a long period of time to avoid such issues. I've read many reports of 4.1 being successfully utilized in production environments long before this official release.

    So, while I'm not saying that everyone should upgrade today, I think the waiting period could be shorter with MySQL than with other technologies.
     
  14. Sinewy

    Sinewy Well-Known Member

    Joined:
    May 15, 2004
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Sydney, Australia
    cPanel Access Level:
    DataCenter Provider
    MySQL Database Server
    Generally Available (GA) 4.1.7
    Generally Available (GA) 4.0.21 / Alpha 5.0.0 / Snapshot 5.0.1-alpha
    Documentation

    it's in GA mode now :)
     
  15. joshb

    joshb Member
    PartnerNOC

    Joined:
    Oct 9, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    I am running mysql 4.1.7 having a few problems. PhpMyAdmin was the 1st but used --old-password option for mysql and this resolved that. I am able to create databases and usersfrom cpanel but users are not showing up in the drop down menus. Cpanel is adding the users correctly. I can login with mysql -u user -p. I am guessing this is either a permissions problem or mysql 4.1 writes users to the user table different then =<4.0.

    Any help would be much appreciated.

    Josh
     
  16. Myacen

    Myacen Well-Known Member

    Joined:
    Apr 6, 2002
    Messages:
    222
    Likes Received:
    0
    Trophy Points:
    16
    Downgrade to a cpanel supported version?
     
  17. joshb

    joshb Member
    PartnerNOC

    Joined:
    Oct 9, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1

    I need the functions of mysql 4.1. Other people reported they have got this working. Any other ideas?
     
  18. barwin

    barwin Active Member

    Joined:
    Jan 5, 2004
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Manhattan
    any clues here?

    I know this isn't too helpful, but thought I'd post it anyway...

    Here is the upgrade guide that MySQL posted for migration from 4.0 to 4.1. It has some tips on user table related stuff, in addition to listing some incompatible changes they've made. Hopefully some clues here?:

    http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
     
  19. joshb

    joshb Member
    PartnerNOC

    Joined:
    Oct 9, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    yes this is helping. I am also finding that the command that cpanel uses is not working exactly right with 4.1.
    This shows up my logs when cpanel tries to read the users
    42 Query select User from user where User REGEXP "^User\_"

    when I run this command from the mysql prompt
    ERROR 1267 (HY000): Illegal mix of collations (utf8_bin,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'regexp'

    Getting closer
     
  20. joshb

    joshb Member
    PartnerNOC

    Joined:
    Oct 9, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    ERROR 1267 (HY000): Illegal mix of collations (utf8_bin,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'regexp'


    setting default character set and collation to utf when starting mysqld will resolve this problem
     
Loading...

Share This Page