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!

Upgraded to MySQL 8.0 issue

Discussion in 'EasyApache' started by 34ever, Dec 14, 2018.

Tags:
  1. 34ever

    34ever Member

    Joined:
    Dec 14, 2018
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Slovenia
    cPanel Access Level:
    Root Administrator
    [​IMG]
    Hey all,

    Would you be so kind and help us solve the following issue. We updated Mysql on our server from 5.7 to 8.0 version.

    Every website on our server works fine except the following (described below). This fatal error occurs, when we try to update Mysql/MariaDB via WHM panel.

    Code:
    -----------------------------------------------------------------------------------
    get_installable_versions_for_version does not know about 8.0 at /usr/local/cpanel/Cpanel/MysqlUtils/Versions.pm line 99.
     at /usr/local/cpanel/Cpanel/MysqlUtils/Versions.pm line 99.
     Cpanel::MysqlUtils::Versions::get_installable_versions_for_version(8.0) called at whostmgr/bin/whostmgr.pl line 6524
     main::mysqlupgrade("mysqlupgrade") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 259
     Whostmgr::Dispatch::_do_call("mysqlupgrade", HASH(0x3efa388), HASH(0x3efcb80)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 157
     Whostmgr::Dispatch::dispatch("mysqlupgrade", 1, ARRAY(0x3efa550)) called at whostmgr/bin/whostmgr.pl line 582
    -----------------------------------------------------------------------------------
    
    Thank you
     
  2. rpvw

    rpvw Well-Known Member

    Joined:
    Jul 18, 2013
    Messages:
    1,088
    Likes Received:
    441
    Trophy Points:
    113
    Location:
    Spain
    cPanel Access Level:
    Root Administrator
    I can't find anything in the cPanel change logs nor feature list that states that cPanel supports or provides MySQL 8

    The following versions of MySQL are available:
    • MySQL 5.5
    • MySQL 5.6
    • MySQL 5.7
    The following versions of MariaDB are available:
    • MariaDB 10.0
    • MariaDB 10.1
    • MariaDB 10.2

    MySQL or MariaDB Upgrade - Version 76 Documentation - cPanel Documentation
    76 Change Log - Change Logs - cPanel Documentation

    If you have forced an upgrade to MySQL 8 using an unsupported method, I would not be surprised if you are experiencing issues.

    You may need to open a support ticket to cPanel to allow them to revert your 'upgrade' ........ if possible !
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. vacancy

    vacancy Well-Known Member

    Joined:
    Sep 20, 2012
    Messages:
    258
    Likes Received:
    30
    Trophy Points:
    28
    cPanel Access Level:
    Root Administrator
    Who gave you this idea?

    You're crazy. :)
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,009
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @34ever,

    MySQL version 8.0 is not offered as part of cPanel & WHM at this time. Did you manually install the RPMs to force it's installation? If so, I recommend reverting the actions you took and restoring MySQL to the state it was in prior to the upgrade.

    You can follow the progress on support for MySQL 8.0 on the following feature request:

    MySQL 8.0 Support

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. 34ever

    34ever Member

    Joined:
    Dec 14, 2018
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Slovenia
    cPanel Access Level:
    Root Administrator
    Hi, all,

    Thank you for all of your replies, but no, I will not revert back to 5.7. Reason? All of the website are running smoothly and without any headaches I experienced when I tested MySql to MariaDB.

    Also, I read so many issues with compatibility MySql upgrade to MariaDB, I cannot afford to put the websites in danger.

    So, my conclusion is the following. Cpanel should support MySql 8 ASAP, since it is so much faster then previous versions and it is very stable.

    If the support Will not be available any time soon, I Will have to find other solutions than Cpanel.
     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,009
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. 34ever

    34ever Member

    Joined:
    Dec 14, 2018
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Slovenia
    cPanel Access Level:
    Root Administrator
    Hi,

    I am writting once again, since I still use Mysql 8.0 (with Centos 7.6). Websites are on steroids, yet of course still isssues with WHM/Cpanel.

    But, I am thinking the following:


    Any suggestions for this. Server managers from all over the world are having problems with me because of my deed since they cannot find me a proper solution (to migrate back to mysql 5.6 and restore all of my cpanel accounts in between).

    Thank you
     
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,009
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @34ever,

    If you wanted to revert back to MySQL 5.7, you could setup a new cPanel & WHM server with MySQL 5.7 and then transfer your accounts to it using WHM >> Transfer Tool. We're happy to help guide you through this process if you have any questions with the transfer process.

    Using MySQL version 8.0 as part of the beta MySQL Governor feature offered by CloudLinux is likely the best choice if MySQL version 8 is an absolute requirement for the system, however note it's a beta product (not intended for a production environment) and CloudLinux warns it's not supported:

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice