Symptoms
-
Plesk upgrade fails with one of the following errors:
MSI: Error! Critical action 'Upgrade data of MySQL Server...' failed:
...
Error: Failed while fetching Server version! Could be due to unauthorized access.
MSI: Error! Critical action 'Upgrade data of MySQL Server...' failed:
...
mysql_upgrade: Got error: 1045: Access denied for user 'psa_root'@'localhost' (using password: YES) while connecting to the MySQL server
Upgrade process encountered error and will not continue. -
Plesk interface is not accessible with Error 500;
Cause
The password for the MySQL user ‘psa_root’ is incorrect.
Resolution
-
Connect to the Plesk server via RDP
-
Create a backup of the Plesk system database:
C:> “%plesk_dir%Mysqlbinmysqldump.exe” -uadmin -p -P8306 psa > C:psa_backup.sql
-
Generate a password for the MySQL user psa_root:
C:> “%plesk_bin%mysqlmng_adm.exe” –inject-root
If the steps above did not help, perform the following actions:
-
Create a new password for the MySQL user psa_root:
C:> “%plesk_bin%mysqlmng_adm.exe” –inject-root –password=”<your_password_here>”
-
Run the
mysql_upgrade
utility:C:> “%plesk_dir%MySQLbinmysql_upgrade.exe” –force “host=127.0.0.1” “port=8306” “user=psa_root” “password=<your_password_here>”