Article ID: 124139, created on Jan 5, 2015, last review on Sep 19, 2016

  • Applies to:
  • Plesk 12.0 for Linux
  • Plesk 12.5 for Windows
  • Plesk 12.0 for Windows
  • Plesk 11.0 for Windows
  • Plesk 11.5 for Windows
  • Plesk 10.4 for Windows

Important: MySQL version 5.7 is not supported by Plesk 12.5


How to upgrade MySQL server from 5.1 to 5.6?


Please note this instruction for CLIENT database server only. You cannot upgrade mysql server with Plesk database.

The easiest upgrade method is to use Plesk autoinstaller. Just type the following command in command line.

plesk installer

MySQL upgrade manual from the vendor can be used also.

Important: Please do not forget to back up data before the upgrade. In general, instructions are the following:

  1. Create dump of all databases, this dump could be helpful in case if something would go wrong:

    "%plesk_dir%\Databases\MySQL51\bin\mysqldump" -uadmin -p<PASSWORD> -P3306 --all-databases --routines > all.dump
  2. Download
  3. For the backup purpose create copy of the following folders, here client databases are saved:

  4. Stop mysql service:

  5. Rename old MySQL51 folder, extract folder from downloaded archive to %plesk_dir%\Databases\ and rename to MySQL51.

  6. Start MySQL server

  7. Upgrade MySQL:

    "%plesk_dir%\Databases\MySQL51\bin\mysql_upgrade" -uadmin -p<PASSWORD>  -P3306

    or starting from Plesk 12.0

    %plesk_bin%\mysqlmng.exe --upgrade-local-service

Note: If admin password for mysql is not known, it should be reseted using KB #116050 - How to reset the MySQL administrator's password

KB #125589 - How to upgrade Plesk MySQL from 5.1 to 5.5 on Linux

Search Words

mysql 5.6

upgrade mysql version update

Mysql 5.5

MySQL Upgrade

upgrade to mysql 5.6

upgrading mysql on windows server

generating the error while import the database

You need MySQL 4.1.20 (or greater)

mysql upgrade fails

upgrade mysql to "5.5"

Upgrade MySQL

upgrade mysql to 5.5

I need to install mysql 5.5

ed7be2b984f9c27de1d2dc349dc19c6d 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8 46a8e394d6fa13134808921036a34da8 bd7fc88cf1b01f097749ae6f87272128 ff5a00b8ead2e480367b019417a04207 c796c01d6951fa24ed54c7f1111667c6 8b661cab116c79dbe6c4ac5bbdf1c8cb 514af229ae32522202a910a2649c80fb 29d1e90fd304f01e6420fbe60f66f838 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF