How To Upgrade MySQL in cPanel post provides instructions on how to upgrade your Apache MySQL database in cPanel via WHM.
Last Updated: October 11, 2020
Latest News: Updated the documentation.
To upgrade MySQL, you will need to login to WHM. This tutorial will show step by step what options to select and the final results.
Note: It is important to always create a backup of your databases. You can also create a backup of your server if you want. Nowadays server backups are done on a daily basis.
How To Upgrade MySQL in cPanel
Step 1 ) Log into WHM (Web Host Manager) as illustrated in the image below. Make sure your login has https in the URL address.
Step 2 ) Go to WHM -> Software -> MySQL/MariaDB Upgrade to begin upgrading MySQL.
7 Steps To Upgrade MySQL
Step 3 ) The following image displays the version MySQL 5.6 (Stable) chosen for this tutorial. Click the Next button once you have select your option.
Step 4 ) The following page with present you with a list of “Upgrade Warnings”. Select the check box for each warning after reading and understanding it. Click on the Continue button when you are ready for the next step.
Note: You will almost always see an advisory suggesting to perform a full MySQL database backup. This is highly recommended.
Step 6 ) The third step allows you to choose from one of the following options. Read each option carefully and choose the correct one for your upgrade.
- Unattended Upgrade (This option was chosen for this tutorial)
- Partially-Interactive Upgrade
- Interactive Upgrade. The latter two options should only be chosen if you have special configurations in place.
- Click on Continue button when you are ready to proceed.
Step 7 ) The following image displays the progress bar letting you know that MySQL is being upgraded.
Step 8 ) The following image display the upgrade process completed without any errors or warnings. This is what you want to see when you upgrade your version. Click on Back button to go back to the beginning.
Step 9 ) Once the process is completed and you return to the beginning you should see your upgraded version. In this example MySQL was upgraded from version 5.5 to version 5.6.35.
Note: If you are upgrading from a version earlier than MySQL 5.5, I recommend that you consult your host before going ahead.
If everything went well then your MySQL is updated. If your run into issues then you will have to contact your host or WHM forums.
I hope the above helps you.
If you have any questions please let me know.