Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Cpanel/Whm 56.0 - Mysql 5.5 upgrade error

Discussion in 'Database Discussion' started by DPNmw, Jun 18, 2016.

  1. DPNmw

    DPNmw Member

    Joined:
    Jan 6, 2016
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    I've tried a few times to upgrade mysql to MariaDB and even Mysql5.6 but the upgrade keeps failing and repeating this error.

    mysql restarted successfully.
    We expected to upgrade to 5.6; however, the system is currently on version 5.5. at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 815.

    Do i have to manually do something via command line to upgrade?
     
    #1 DPNmw, Jun 18, 2016
  2. DPNmw

    DPNmw Member

    Joined:
    Jan 6, 2016
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Never mind the cpanel tech support did the upgrade for me. Seems the host provider vps came with a custom version of mysql on initial setup.
     
    #2 DPNmw, Jun 18, 2016
  3. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,777
    Likes Received:
    93
    Trophy Points:
    353
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    Did you get any errors while upgrading
    what does mysql -v say you are running
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 dalem, Jun 18, 2016
  4. twhiting9275

    twhiting9275 Well-Known Member

    Joined:
    Sep 26, 2002
    Messages:
    556
    Likes Received:
    16
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Twitter:
    You're not going to want to manually upgrade. That will cause cPanel to throw a big old fit.
    Your 'error message' really isn't an error message at all. The output of mysql -v will help, as mentioned above.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 twhiting9275, Jun 18, 2016
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,442
    Likes Received:
    1,962
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I'm happy to see the issue is now resolved. Thank you for updating us with the outcome.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelMichael, Jun 21, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - Cpanel Mysql upgrade
  1. Jeff P.

    [CPANEL-23547] MySQL down after failed MariaDB upgrade

    Jeff P., Nov 7, 2018, in forum: Database Discussion
    Replies:
    12
    Views:
    202
    cPanelMichael
    Nov 8, 2018
  2. MHD_MUS

    cPanel mysql backup Error 1045

    MHD_MUS, Dec 7, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    124
    cPanelLauren
    Dec 10, 2018 at 1:07 PM
  3. kernow

    SOLVED [CPANEL-22320] Table mysql/innodb_index_stats has length mismatch

    kernow, Nov 11, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    398
    kernow
    Nov 13, 2018
  4. dswimr615

    SOLVED Associate MySQL Database with cPanel User

    dswimr615, Nov 10, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    521
    cPanelMichael
    Nov 12, 2018
  5. zTurko

    Does cPanel Support MySQL 8?

    zTurko, Oct 25, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    236
    cPanelMichael
    Oct 25, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice