Plesk upgrade failed: ERROR: The installation of the package 'mysql-server-configurator' failed

Created:

2016-11-16 13:06:52 UTC

Modified:

2017-08-16 17:17:29 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk upgrade failed: ERROR: The installation of the package 'mysql-server-configurator' failed

Applicable to:

  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

Plesk upgrade or update failed with the following error:

MSI: Error! Critical action 'Updating MySQL Server component...' failed:
Command "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\defpackagemng.exe" --set "--type=mysqlserver" "--default=mysql56" failed with code 1. Output: Execute mysqlmng --add-local-super-user failed with error code 1:
Failed to connect to database: Access denied for user 'local_mysql_root'@'127.0.0.1' (using password: YES)
Failed to install 'C:\\ParallelsInstaller\\parallels\\PANEL-WIN_12.0.18\\dist-msi-Microsoft-2003-i386\\mysql-server-configurator.msi': Fatal error during installation. (Error code 1603)

ERROR: The installation of the package 'mysql-server-configurator' failed with code 1603. (upgrade: update configuration of MySQL server...)
Not all packages were installed.
Please, contact product technical support.

Cause

DB server misconfiguration

Resolution

  1. Reset Plesk admin password

    "%plesk_bin%"\\plesksrvclient.exe -set PASSWORD
    "%plesk_bin%"\\plesksrvclient.exe -set PASSWORD true
  2. Add skip_grant_tables to %plesk_dir%\\Databases\\MySQL\\data\\my.ini

  3. Restart MySQL service

    net stop MySQL && net start MySQL
  4. Re-run Plesk installer

  5. Upon completion remove skip_grant_tables from %plesk_dir%\\Databases\\MySQL\\data\\my.ini

If the steps above did not help, please refer to KB article #213389409

Have more questions? Submit a request
Please sign in to leave a comment.