Article ID: 112498, created on Oct 11, 2011, last review on May 11, 2014

  • Applies to:
  • Plesk 10.x for Windows
  • Plesk 9.x for Windows
  • Plesk 6.5 for Windows
  • Plesk 8.x for Windows
  • Plesk 7.x for Windows

Symptoms

When attempting to log in to Parallels Plesk Control 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.")

Cause

The password used to access the Parallels Plesk Panel database does not match the saved admin password.

Resolution

Reset this password on the database server side using the following steps:
(MySQL server is used as the provider for the Parallels Plesk Panel database.)

1. Determine the current password used to access the Parallels Plesk Panel database:
%plesk_bin%\plesksrvclient.exe -get

2. Start the MySQL database server with the skip_grant_tables flag:

 -  Edit the MySQL configuration file %plesk_dir%\mysql\data\my.ini.
 -  Add the skip_grant_tables=1 parameter to the [PleskSQLServer] section.
 -  Restart the Parallels Plesk Panel SQL server service.

3. Log in to the Parallels Plesk Panel MySQL server.
%plesk_dir%\mysql\bin\mysql.exe -P8306 mysql
Execute the following query:
update mysql.user set password=password('<current_password>') where user='admin';

4. Revert the changes made in step 2.

5. Restart the service on the Parallels Plesk Panel SQL server.

Note: As of Parallels Plesk Panel version 9.x, you can use the following command to update the admin's password:
"%plesk_bin%\plesksrvclient.exe" -set newadminpassword true


MSSQL server is used as the provider for the Parallels Plesk Panel database.

Log in under the local administrator account, and use the following command to reset the password:
osql -E -Q "exec sp_password NULL,'new_password','admin'" 

0a0d02e01be7d690fc52e3793fabc9e5 a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 c45acecf540ecd42a4bbfb242ce02b1d c0c38d2367acfa8909699e0b34b01dea aac4a8fcd879de03758354e15495d69a c796c01d6951fa24ed54c7f1111667c6 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF