Upgrade MySQL in cPanel is quite easy. Here is the short look for upgrading your MySql from 5.1 to 5.5 in a cPanel server.

1. Take the backup of all the databases on the server.

#mysqldump –all-databases > all_databases.sql

2. Replace the MySQL version from 5.1 with 5.5 in /var/cpanel/cpanel.config file.

#vi /var/cpanel/cpanel.config
and then, change
======
“mysql-version=5.1” to “mysql-version=5.5”.
======

3. Then, run

#/scripts/check_cpanel_rpms –fix

4. After executing this command, try

#mysql -V

MySQL will be upgraded to 5.5. Then try, php -v. You will get the following error:

——————-
root@server [~]# php -v
php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory
——————–

Do an easyapache to fix this.

#/scripts/easyapache

Done!

Leave a Reply

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