Plesk update or upgrade fails: Upgrade data of MySQL Server, Access denied for user ‘psa_root’@’localhost’

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

1. Connect to the Plesk server via RDP

2. Create a backup of the Plesk system database:

   C:> “%plesk_dir%Mysqlbinmysqldump.exe” -uadmin -p -P8306 psa > C:psa_backup.sql

3. Generate a password for the MySQL user psa_root:

   C:> “%plesk_bin%mysqlmng_adm.exe” –inject-root

4. Rerun the Plesk update (or upgrade).

If the steps above did not help, perform the following actions:

1. Create a new password for the MySQL user psa_root:

   C:> “%plesk_bin%mysqlmng_adm.exe” –inject-root –password=”<your_password_here>”

2. 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>”

3. Rerun the Plesk update (or upgrade).