How to upgrade MySQL from 5.1 to 5.5 in Plesk server?

Today, In this post we will discuss about the steps to upgrade MySQL version from native 5.1 to 5.5 on Plesk 12.5 version with CentOS 6 OS. By default the Plesk 12.5 comes with MySQL version 5.1.

MySQL upgrade can not be possible from Plesk auto-installer as MySQL 5.5 isn’t listed in its base repository. So That’s why we need a third party repo to upgrade MySQL and that’s from Atomic repo.

How to Upgrade:

First of all make sure to you have backups of all databases on your server. This would help you in case of any problems with MySQL version upgrade.

Step 1 : First of all we need to download the atomic repo

# wget -q -O - | sh

Step 2 : Upgrade MySQL

# yum upgrade mysql
# mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

Now all your tables will get updated to the new version.

If somehow you’re getting the following errors:

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Error: Failed while fetching Server version! Could be due to 
unauthorized access.
FATAL ERROR: Upgrade failed

Let’s check the MySQL error logs in the location /var/log/mysqld.log. If the InnoDB turned corrupt, turn on innodb_force_recovery and repair Innodb tables. Once the InnoDB problem is fixed you can proceed with the mysql_upgrade command.

That’s all we have to do.  You also like to know How to setup Phpmyadmin on Ubuntu 16.04 LAMP Server, Please check and also Give your opinion below if you experience any issues or to discuss your ideas and experiences.