Upgraded to MySQL 8.0 issue
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.
-----------------------------------------------------------------------------------
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
-
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
- MariaDB 10.0
- MariaDB 10.1
- MariaDB 10.2
0 -
Who gave you this idea? You're crazy. :) 0 -
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.0 -
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. 0 -
Hello @34ever, We'll update the Beta: MySQL 8.0 for MySQL Governor released Thank you. 0 -
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: - to switch CENTOS OS to Cloudlinux OS CloudLinux - Main | New template
- since Cloudlinux released MySQL Governor for MySQL 8 in beta, install this version Beta: MySQL 8.0 for MySQL Governor released
0 -
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: [QUOTE]cPanel does not officially support MySQL 8.0, that is why we don"t recommend to use it on cPanel servers.
Thank you.0
Please sign in to leave a comment.
Comments
7 comments