How to Upgrade MySQL on cPanel Server

The easiest methods to upgrade MySQL to MySQL5.5  on cPanel server

You can upgrade your server’s MySQL version with WHM’s “MySQL Upgrade” interface, which is located at:

Home >> Software >> MySQL Upgrade.

Or please follow the steps to upgrade it from commandline

Check MySQL version

 mysql -V
mysql Ver 14.14 Distrib 5.1.73, for unknown-linux-gnu (x86_64) using readline 5.1

First stop MySQL and backup MySQL folder so that you can use it if anything goes wrong

Stop MySQL

/etc/init.d/mysql stop

Copy /var/lib/mysql Directory

cp -rf /var/lib/mysql /home/MySQL_backup/

Also take a MySQL dump of all databases

mysqldump --all-databases > All_db_backup.sql

Now edit the file

vi /var/cpanel/cpanel.config

Change

mysql-version=5.1 to mysql-version=5.5

Now Run

/scripts/check_cpanel_rpms --fix

No do an easy Apache to  install any missing modules

/scripts/easyapache --force

 

Monthly server support with Unlimited tickets, 24×7 monitoring, Security Audit and lot more for just $59