Note: These steps will work only with the cPanel version 88 and later. Please refer to the below steps at your own risk. We strongly recommend you to take the full backup of your entire server as well as MySQL/MariaDB databases before performing the steps. These steps will not work for CloudLinux OS.
You will not be able to downgrade your DB version once you are done with these steps. Also, you will need to make sure all of your databases are compatible with your new version of MySQL/MariaDB.
cPanel system will upgrade MySQL to MariaDB. In case, you change the DB engine to MariaDB, it can’t be changed to MySQL again.
In this tutorial, we will upgrade the MySQL from 5.6 to 5.7 version on centos. Once you select the required version MySQL/MariaDB, WHM will automatically keep the DB engine up to date. So the new patches released by the vendor will automatically be applied by WHM.
- Login to your WHM Panel.
- Go to SQL Services and click on MySQL/MariaDB Upgrade.
- Select the required MySQL version on which you want to upgrade and click on the continue button.
- Select the checkbox of each warning and click on the continue button.
- Next, select the type of upgrade you want to perform.
- Unattended-Upgrade — In this option Apache and PHP will be automatically rebuilt with the last saved defaults. Also, updates Ruby Gems and rebuilds automatically.
- Interactive Upgrade — This option steps you through the upgrade process. It includes MySQL or MariaDB upgrade, Ruby Gems update, and Apache, PHP rebuild.
We have selected unattended-upgrade for our steps and clicked on the continue button. Upgrade will be in progress at the moment.
- You will see the below screen once the upgrade is completed. The upgrade process completed successfully.
You can verify it from ssh using the below command as well.