Question
How to upgrade MySQL from the version 5.1 to 5.5 on Linux?
Answer
Plesk Installer gets packages from base repositories of an operating system installed.
If MySQL 5.5 is not listed in the base repository, it is not available in Plesk Installer.
In that case, in order to upgrade MySQL version to 5.5, it is needed to configure a third-party repository.
Note: Upgrade can be performed in a command-line interface with the instructions below at your own risk. This task is supposed to be performed by a system administrator.
Note: PHP package can also be upgraded during this procedure. Oracle MySQL yum repository is supported only by Plesk Onyx. Also, it is required to have an SSH connection to the server with administrative privileges.
Install the Atomicorp repository:
# wget -q -O - https://www.atomicorp.com/installers/atomic | sh
Upgrade MySQL:
# yum upgrade mysql
Restart the MySQL service:
# service mysqld restart
Upgrade MySQL databases:
# mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`
Execute this command to update the package version inside Plesk:
# plesk bin service_node --update local
Update all system packages:
# apt-get update
Upgrade MySQL:
# apt-get upgrade mysql-server
Restart the MySQL service:
# service mysql restart
Upgrade MySQL databases:
# mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`
Execute this command to update the package version inside Plesk:
# plesk bin service_node --update local
