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. 

Related Articles

How to Protect GRUB with Password in Linux ?

GRUB called as Grand Unified Bootloader is a default Boot loader on Unix OS. In a Linux system,...

How to check PHP and Apache Modules that are Installed on a Linux?

Following are the steps to check which PHP and Apache Modules are installed on Linux. Login via...

How to run ClamAV scan from SSH in cPanel server?

In this article, we'll discuss how to run ClamAV scan via SSH in cPanel/WHM server. ClamAV is one...

How to upgrade Debian 7 (Wheezy) to 10 (Buster) version?

It is always recommended to upgrade the version to prevent any security vulnerability. You can...

How to redirect http to https using .htaccess?

If you have installed SSL Certificate on your website and want to redirect your website traffic...

  • 0 Users Found This Useful

Was this answer helpful?