How to upgrade MySQL/Maria DB in WHM/cPanel?

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. 

  1. Login to your WHM Panel.

  2. Go to SQL Services and click on MySQL/MariaDB Upgrade.



  3. Select the required MySQL version on which you want to upgrade and click on the continue button.



  4. Select the checkbox of each warning and click on the continue button.



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

        

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

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to Move Accounts From One cPanel Server To Another cPanel server?

cPanel facilitates you with the built-in Transfer Tools which allow you to migrate your existing...

How to install OPcache in cPanel/WHM?

OPcache is a PHP extension and it helps to improve the performance of your php Website. OPcache...

How to add my SSH key to Github/Bitbucket?

Are you looking to deploy your websites using GitHub or Bitbucket to Accuwebhosting? It is very...

The action Install for product MySQL Server 5.7.19 failed.

You may face this error while installing MySQL 5.7 or upgrading MySQL 5.6 to 5.7. Here, is the...

How to Install A-AST Linux Malware Detect Interface in cPanel/WHM?

You can scan your cPanel VPS and dedicated server against malware and keep your environment clean...