Oct 072020
 

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.

update-php-version-vpn-server-log-into-whm

Step 2 ) Go to WHM -> Software -> MySQL/MariaDB Upgrade to begin upgrading MySQL.

apache-mysql-upgrade1

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.

apache-mysql-upgrade2

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.

apache-mysql-upgrade3

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.

Upgrade Type

  • 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.

apache-mysql-upgrade4

Step 7 ) The following image displays the progress bar letting you know that MySQL is being upgraded.

apache-mysql-upgrade5

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.

apache-mysql-upgrade6

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.

apache-mysql-upgrade7

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.

Enjoy.

I have been working in IT since 1999 and I enjoy the challenges it brings me. I love developing websites with WordPress. I spend a lot of time helping out in wordpress.org forums. I have been writing tutorials since 2011. Now I am learning how to manage my own VPS "Virtual Private Server.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)

sixteen + 9 =