34ever

Member
Dec 14, 2018
7
0
1
Slovenia
cPanel Access Level
Root Administrator

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
 

rpvw

Well-Known Member
Jul 18, 2013
1,101
459
113
UK
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 !
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,218
463
We updated Mysql on our server from 5.7 to 8.0 version.
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.
 

34ever

Member
Dec 14, 2018
7
0
1
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.
 

34ever

Member
Dec 14, 2018
7
0
1
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,218
463
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:

cPanel does not officially support MySQL 8.0, that is why we don’t recommend to use it on cPanel servers.
Thank you.