Plesk login page shows “Unable to connect to database : saved admin password is incorrect”
When try to login to Plesk admin panel the following error is displayed.
Unable to connect to database: saved admin password is incorrect. 0: C:\\Program Files\\SWsoft\\Plesk\\admin\\auto_prepend\\auth.php3:56 psaerror(string “Unable to connect to database: saved admin password is incorrect.”)
Reason:
The main reason for the issue is the PSA database user password and the Plesk admin password mismatch.
Solution:
Step 1 : Confirm the Plesk admin password. You can get the current Plesk password with command below.
%plesk_bin%\plesksrvclient.exe -get
Step 2 : Edit the MySQL configuration file(my.ini - %plesk_dir%\mysql\data\).
[C:\Program Files\Parallels\Plesk\mysql\data\]
Add the skip_grant_tables=1 parameter and restart the Plesk SQL Server service.
Note : Add to the [PleskSQLServer] section, NOT to [Client] section.
Step 3 : Reset the password
Type the below command to get into the MySQL prompt,
C:\Program Files\Parallels\Plesk\mysql\bin\mysql.exe -P8306 mysql
Now from the MySQL prompt, type
update mysql.user set password=password(’current_password’) where user=’admin’;
where ‘current_password’ is the current Plesk password.
Step 4 : Revert the changes
Remove the parameter ’skip_grant_tables=1′ from the MySQL configuration file and restart service Plesk SQL Server.
You should get the plesk admin page now