Plesk upgrade failed - Access denied for user 'local_mysql_root'

Created:

2016-11-16 13:03:03 UTC

Modified:

2017-04-24 11:59:11 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk upgrade failed - Access denied for user 'local_mysql_root'

Applicable to:

  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

Plesk upgrade failed, the error message is shown:

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.

If you getting an error in autoinstaller3.log where host is differ from localhost , for example 'local_mysql_root'@'1.2.3.4'

Execute  "C:\\Program Files (x86)\\Parallels\\Plesk\\Databases\\MySQL51\\bin\\mysqladmin.exe" --port=3306 -ulocal_mysql_root -p<PASSWORD> shutdown failed: 
C:\\Program Files (x86)\\Parallels\\Plesk\\Databases\\MySQL51\\bin\\mysqladmin.exe: connect to server at 'localhost' failed

error: 'Access denied for user 'local_mysql_root'@'1.2.3.4' (using password: NO)'

and you're even not able to connect with skip-grant-tables option enabled

Cause

Windows port redirection/forwarding was enabled

Resolution

  1. Ensure that there is no port redirection from 127.0.0.1:3306

    netsh interface portproxy show all

    Listen on ipv4: Connect to ipv4:

    Address Port Address Port
    --------------- ---------- --------------- ----------
    127.0.0.1 3306 1.2.3.4 3306
  2. To remove port redirection use the following command:

    netsh interface portproxy delete v4tov4 listenport=3306 listenaddress=127.0.0.1
Have more questions? Submit a request
Please sign in to leave a comment.