How to Upgrade MySQL on cPanel Server

Stop worrying about your server.

cPanel/Plesk Server Management for just $59/mo with Unlimited tickets, Unlimited admin hours, Security audits, 24×7 monitoring and lot more 

cPanel Server Management  $59/mo Click here

Plesk Server Management $59/mo Click here

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 

Server Management at just $59

Leave a Reply

Your email address will not be published. Required fields are marked *