cPanel announced yesterday that it will block all updates to the server if it still uses MySQL 5.5. This means if you have been putting off upgrading your MySQL server wide, now is the time to do it. Not getting updates mean security and performance issues will soon follow. If you have a password warning for old MySQL users that use the old password structure. You will need to add a new user and update your scripts.
It's a tricky process, but very doable for anyone willing to spend 20 minutes.
This is only relevant for older VPS and dedicated servers that use MySQL 5.5 and older passwords. All shared and cloud services are updated. MySQL will give you a warning and list all users not compatible (if any) when you start the upgrade.
To make your passwords compatible, you need to open the MySQL section in your account's cPanel. There, you need to add a new MySQL user. Then, you need to connect the new MySQL user to the database with all permissions clicked. Now you are half way :)
Make sure and save the new MySQL user's username and password. I would cut and paste both into a text file.
Now you need to find how your scripts connect to MySQL. Wordpress for example uses the file. wp-config.php
In that file you need to change the username and password that was used in the MySQL section for the new MySQL user.
That's it! Now test it out. If you get a can't connect to database error, go over each step and make sure they were all done and the new user login and password is correct.
--------- cPanel's official press release ---------
Upgrading MySQL or MariaDB
cPanel & WHM Version 80 will not support MySQL 5.5, and updates to cPanel & WHM Version 80 will be blocked for any server still running MySQL 5.5. We are also blocking updates for any cPanel & WHM servers that connect to MySQL 5.5 servers running. The MySQL/MariaDB Upgrade interface inside WHM makes upgrading safe and easy.
Why the block?
On December 31st, 2018, MySQL version 5.5 entered End of Life status. Any server currently running MySQL 5.5 will not receive any updates, bug fixes, or security patches for MySQL until MySQL is updated to a version 5.6 or later.
What does this block mean?
You must upgrade MySQL (or move to a supported version of MariaDB) before you can upgrade to cPanel & WHM Version 80. We are also blocking upgrades for servers that connect to remote database servers running MySQL 5.5 and earlier. You must disconnect from those servers or upgrade them to use MySQL 5.6 or later (or change to MariaDB). Otherwise, you will not be able to upgrade to cPanel & WHM version 80.
MySQL 5.7
MySQL 5.7 was released on October 21st, 2015, but we didn’t add support for it until v70. We discussed the reason for the delay in our blog post Being a Good Open Source Community Member: Why we hesitated on MySQL 5.7. The improvements in MySQL 5.7 are vast and certainly worth the time to upgrade. A member of our training team did a presentation at last year’s cPanel Conference comparing MySQL 5.7 to MariaDB 10.2. Take a look at his slides for a deeper dive.
When will support for 5.6 end?
While we had previously planned to end support for 5.6 earlier, we have extended our support to Oracle’s defined End of Life for MySQL version 5.6. It is currently expected to reach End of Life on February 5, 2021. We strongly recommend upgrading to MySQL 5.7 before that time, to take advantage of the new features and overall speed improvements that 5.7 brings with it.
Upgrading your MySQL version
To update your server you can use WHM’s MySQL/MariaDB Upgrade interface. Simply select the version of MySQL or MariaDB that you would like to upgrade to, and the software does the rest of the work! You can read more about this interface in our documentation. We recommend upgrading one version at a time, to ensure the most stability.
If your server To view your server’s connections to remote MySQL servers, use WHM’s Manage MySQL Profiles interface.
https://documentation.cpanel.net/display/80Docs/Manage+MySQL+Profiles
FAQ
We frequently see this type of change trigger some very reasonable questions. To help users find answers more quickly and easily, we wanted to include a list of those questions and their answers.
Can you switch back to MySQL after converting to MariaDB?
No, on cPanel & WHM servers it is not currently possible to migrate back to MySQL once you migrate to MariaDB. If this is a feature you’d like to see, make sure to add your vote on the feature request site, so you will be notified if we do add that feature.
How do I verify databases on my websites are working well post-upgrade?
The best way is to test the websites in a browser and look for database errors and to watch for errors in the MySQL error log. Unless you have customized the error log in your configuration file ( /etc/my.cnf ), then you will find it named $hostname.err in /var/lib/mysql/. For example, if your hostname is ‘host.example.com’, the name of the file will be host.example.com.err. Don’t attempt to edit this file. Only use commands like tail or cat to interact with it:
tail /var/lib/mysql/`hostname`.err
I got the message from cPanel, need me to upgrade to Mysql 5.7. Is that safe? My server is running WordPress multisite and WHMCS, are those safe?
Yes, both of these applications are safe and compatible with MySQL 5.7.
I have 20+ websites on our server with databases. Is updating MySQL like updating PHP where each account needs to be checked after updating, or should sites that worked in 5.5 still work in 5.7? Or are there certain things I should look out for?
Like with PHP upgrades, we recommend checking each site for problems and checking the error logs, to ensure that you catch any problems with your customers’ sites as quickly as possible.
I keep receiving notifications that my MySQL version is outdated and that I should update. However, I am very hesitant simply because I do not want to be held responsible for any compatibility issues with each account especially those we did not develop. Is this a required upgrade?
Yes, this upgrade is required. We recommend that you contact your customers to give them plenty of notice for your planned server maintenance and ensure that you have account backups enabled.
When will cPanel & WHM Support MySQL Version 8?
Our addition of MySQL hasn’t been assigned a version yet, but it’s certainly something we want to get added. We are hoping to add it in 2019. Add your voice on the feature request site to ensure you get notified when we do add it!
Thursday, March 21, 2019
