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

Symptoms

1. 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)

2. Login in Plesk and database is possible via directive skip-grant-tables in %plesk_dir%\Databases\MySQL\my.ini (not in %plesk_dir%\MySQL\my.ini). Plesk SQL Server has no effect on the Plesk operability.

3. 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 some_username.

Cause

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

Plesk SQL Server is customized to be running on client database server on port 3306 instead of 8306.

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.