Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)

Symptoms

• Plesk and plesk database psa are not accessible with the error:

  PLESK_INFO: ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: YES)

• There are the following customizations in the Windows registry key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PLESK\PSA Config\Config\

  • MySQL_DB_PORT is set to 3306 instead of default 8306;

  • PLESK_DATABASE_LOGIN was changed from the default admin to username.

Cause

Plesk database login password stored in the Windows registry does not match with custom Plesk database user username stored in the Plesk SQL server database.

Resolution

1. Connect to the server via RDP;

2. Edit the file %plesk_dir%\Databases\MySQL\my.ini add skip-grant-tables directive to the [MySQL] section;

3. Restart the MySQL57 service in Start > Services;

4. Log in to MySQL server on port 3306. According to the customizations it should be possible via the command in CMD:

   C:\> plesk db

5. Update the password (authentication_string for MySQL 5.7) for the user from the error and from the registry record PLESK_DATABASE_LOGINusername in mysql database:

   MYSQL_LIN: UPDATE mysql.user SET authentication_string=PASSWORD("password") WHERE user='username';

6. Set the same password as in step 4 for Plesk via the command in CMD:

   C:\> plesk sbin psadb -u --password="password"

7. Remove the skip-grand-tables directive from %plesk_dir%\Databases\MySQL\my.ini;

8. Restart the MySQL57 service in Start > Services.

Additional Information

ERROR PleskMainDBException Access denied for user 'admin'@'localhost' (using password: YES)