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 upgrade via Software does not show MySQL 5.5

Discussion in 'Database Discussions' started by Erjen, Jul 14, 2014.

  1. Erjen

    Erjen Member

    Joined:
    Jul 14, 2014
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    My current MySQL version is 5.1.63. I got this error:
    Code:
    fatal: Newer releases of cPanel & WHM are not compatible with your MySQL version: 5.1. Upgrade your MySQL server to a version greater or equal to 5.5
    Now I am trying to update MySQL via Software > Update MySQL but MySQL 5.5 is just not shown there.. very strange. Can anyone help me?

    CentOS 6.5
    WHM 11.30.8 (build 0
    MySQL 5.1.63


    Thanks!
     
  2. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    You are on a version of cPanel that doesn't support 5.5. Try upgrading to 11.38 first, then upgrade MySQL to 5.5. To do this, you'll need to SSH into your server and edit /etc/wwwacct.conf, set CPANEL=11.38, then run /scripts/upcp.
     
  3. Erjen

    Erjen Member

    Joined:
    Jul 14, 2014
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks for your response.
    I tried to update cPanel, but there was no line in wwwact.conf with CPANEL=
    So I manually set that line with 11.38, run the script but cPanel still says it is 11.30.8 and MySQL 5.5 still doesn't show up..

    Any idea's?

    Thanks again!
     
  4. triantech

    triantech Well-Known Member

    Joined:
    Jul 1, 2014
    Messages:
    145
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Kochi, India, India
    cPanel Access Level:
    Root Administrator
    Hi,

    Try setting the value CPANEL=11.38 in the file /etc/cpupdate.conf
     
  5. Erjen

    Erjen Member

    Joined:
    Jul 14, 2014
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thank you! Works perfectly. All is good now
     
  6. triantech

    triantech Well-Known Member

    Joined:
    Jul 1, 2014
    Messages:
    145
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Kochi, India, India
    cPanel Access Level:
    Root Administrator
    Erjen,

    Great to know :)
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  8. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    Ugh, yea, sorry. /etc/cpupdate.conf is what I meant :rolleyes:
     
Loading...

Share This Page