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:

  CONFIG_TEXT: MSI: Error! Critical action 'Upgrade data of MySQL Server...' failed:
  Command "C:\Program Files (x86)\Parallels\Plesk\admin\bin\mysqlmng_adm.exe" --up
  grade-server-data "--initial-ver=5.5" "--target-ver=5.5.52" failed with code 1.
  Output: Stop service...
  Removing InnoDB log files...
  Start service...
  Upgrading all databases...
  Execute C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysql_upgrade.exe --for
  ce "--host=127.0.0.1" "--port=8306" "--user=psa_root" "--password=*" failed[1]:
  Looking for 'mysql.exe' as: C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mys
  ql.exe
  Looking for 'mysqlcheck.exe' as: C:\Program Files (x86)\Parallels\Plesk\MySQL\bi
  n\mysqlcheck.exe
  Error: Failed while fetching Server version! Could be due to unauthorized access.

  OR

  CONFIG_TEXT: FATAL ERROR: Upgrade failed
  
  at (execExtUtilChecked line 137)
  at execute console command --upgrade-server-data(vconsoleapp::start line 122)
  \
  at execute "C:\Program Files (x86)\Parallels\Plesk\admin\bin\mysqlmng_adm.exe
  " --upgrade-server-data "--initial-ver=5.5" "--target-ver=5.5.52"(vconsoleapp::r
  un line 139)
  
  at (CmdAction::Commit line 412)
  at Execute action Upgrade data of MySQL Server...(executeList line 290)
  Failed to install 'C:\ParallelsInstaller\parallels\PANEL-WIN_17.0.17\dist-msi-Mi
  crosoft-2003-i386\mysql-admin.msi': Fatal error during installation. (Error code 1603)

  OR

  CONFIG_TEXT: ERROR: The installation of the package 'mysql' failed with code 1603. (upgrade:
  Upgrading Plesk SQL server...)
  Not all packages were installed.
  Please contact product technical support.
  exit status 1

  OR

  CONFIG_TEXT: Execute C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\mysql_upgrade.exe --force --host=127.0.0.1 --port=8306 --user=psa_root --password=************ failed[1]: Looking for 'mysql.exe' as: C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\mysql.exe
  Looking for 'mysqlcheck.exe' as: C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\mysqlcheck.exe
  FATAL ERROR: Upgrade failed

  OR

  CONFIG_TEXT: MSI: Error! Critical action 'Upgrade data of MySQL Server...' failed:
  Command "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\mysqlmng_adm.exe" --up
  grade-server-data --initial-ver=5.5 --target-ver=5.5.41 failed with code 1.
  Output:
  Stop service...
  Removing InnoDB log files...
  Start service...
  Upgrading all databases...
  Can't decrypt data
  Failed to install 'C:\\ParallelsInstaller\\parallels\\PANEL-WIN_12.0.18\\dist-msi-Mi
  crosoft-2003-i386\\mysql-admin.msi': Fatal error during installation. (Error code 1603)
  
  ERROR: The installation of the package 'mysql' failed with code 1603. (upgrade:
  upgrading Parallels Panel SQL server...)

  OR

  CONFIG_TEXT: MSI: Error! Critical action 'Upgrade data of MySQL Server...' failed:
  Command "C:\Program Files (x86)\Parallels\Plesk\admin\bin\mysqlmng_adm.exe" --up
  grade-server-data --initial-ver=5.7 --target-ver=5.7.26 failed with code 1.
  Output: Stop service...
  Removing InnoDB log files...
  Start service...
  Upgrading all databases...
  Execute C:\Program Files (x86)\Plesk\MySQL\bin\mysql_upgrade.exe --force "--host=127.0.0.1" "--port=8306" "--user=psa_root" "--password=*" failed[11]: mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
  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.
  
  at (execExtUtilChecked line 138)
  at execute console command --upgrade-server-data(vconsoleapp::start line 93)
  at execute "C:\Program Files (x86)\Plesk\admin\bin\mysqlmng_adm" --upgrade-server-data "--initial-ver=5.7" "--target-ver=5.7.26"(vconsoleapp::run line 110)exit status 1

• 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%\Mysql\bin\mysqldump.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%MySQL\bin\mysql_upgrade.exe" --force "host=127.0.0.1" "port=8306" "user=psa_root" "password=<your_password_here>"

3. Rerun the Plesk update (or upgrade).