Applicable to:
- Plesk for Windows
Symptoms
-
Plesk upgrade fails with one of the following errors:
CONFIG_TEXT: MSI: Error! Critical action 'Upgrade data of MySQL Server...' failed:
...
Error: Failed while fetching Server version! Could be due to unauthorized access.
CONFIG_TEXT: 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%\Mysql\bin\mysqldump.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%MySQL\bin\mysql_upgrade.exe" --force "host=127.0.0.1" "port=8306" "user=psa_root" "password=<your_password_here>"
Comments
2 comments
Hello,
is it safe to change the psa_root password?
I need to access the db with phpmyadmin in order to easily set the externalid of whmcs.
@Pier Paolo Ronzino
It is not required to change password for psa_root.
You could log into psa database using the command
psa db
And create the appropriate user for phpmyadmin. BTW, you could use pmpmyadmin provided by Plesk, it is automatically configured.
Please sign in to leave a comment.