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 modify the maximum number of POP3 connections in WHM/cPanel?

In case, you are getting the error Error – Maximum number of connections from user+IP exceeded...

Do You Provide TUN/TAP On VPS Hosting?

Typically, TUN/TAP is used when you want to utilize VPN services from your VPS. Windows VPS...

How to Enable Plaintext Authentication in Dovecot?

Dovecot is an Open source IMAP or POP3 server used to create light-weight and high-performance...

How To Add A New IP Address In Virtualmin?

You can add an IP Address via Networking Module directly with virtualmean. To do this, you need...

How to Install Minecraft Game Server in Linux VPS?

This article will assist you to install Minecraft Server in your Linux VPS. Checkout our VPS...

  • 0 Users Found This Useful

Was this answer helpful?