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