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.
and then, change
“mysql-version=5.1” to “mysql-version=5.5”.
3. Then, run
4. After executing this command, try
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.