How to upgrade Plesk MySQL from 5.1 to 5.5 on Linux

Refers to:

  • Plesk 12.5 for Linux
  • Plesk Onyx for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 12:45:09 UTC

Modified:

2017-02-17 20:11:36 UTC

4

Was this article helpful?


Have more questions?

Submit a request

How to upgrade Plesk MySQL from 5.1 to 5.5 on Linux

Question

How to upgrade MySQL server from 5.1 to 5.5 on Linux?

Answer

Plesk autoinstaller gets packages from base repositories of an operating system installed.

If MySQL 5.5 is not listed in the base repository, it will not be available for Plesk autoinstaller.

In that case, to upgrade MySQL version to 5.5, it is needed to configure a third-party repository.

On RedHat-based systems Atomic repository can be used:

# wget -q -O - http://www.atomicorp.com/installers/atomic | sh
# yum upgrade mysql
# mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

In case if the following message appears, please refer to Error during yum upgrade: "Packages excluded due to repository protections" article:

# yum upgrade mysql
....
881 packages excluded due to repository protections
No Packages marked for Update

On Debian-based systems MySQL 5.5 should be available from default repositories:

# apt-get update
# apt-get upgrade mysql-server
# mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

Note

  • PHP package may also be upgraded during this procedure.
  • Oracle MySQL yum repository is not supported by Plesk.

Additional information

How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows

How to upgrade Plesk MySQL from 5.5 to 5.6 on Linux

Have more questions? Submit a request

2 Comments

  • 0
    Avatar
    Greg Sims

    I am running RHEL 6.  This process will not work using sudo -- you must be root.  Issue "sudo su" prior to issuing the commands above.

  • 1
    Avatar
    Anton Maslov

    @Greg,

     

    In general articles are written considering that all the commands will be invoked with root privileges since we do not know how exactly our customers work on the server (under root or not).

    Thank you for the comment - I believe it will be useful for other Pleskians :)

     

Please sign in to leave a comment.