Unable to create a database dump in Plesk > Domains > example.com > Databases > Export Dump:
mysqldump: Got error: 1045: Access denied for user 'admin'@'localhost' (using password: YES) when trying to connect
Attempts to manage a customer's MySQL databases or remove mailbox produces errors:
Error: Connection to the database server has failed because of network problems: Try to establish connection failed
Error: Connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'localhost' (using password: YES)
The MySQL server is marked red on the Tools & Settings > Database Servers screen.
Plesk stores an incorrect MySQL server administrator password.
To solve the issue and reconnect Plesk to the MySQL server do the following:
Connect to the server using RDP.
Edit the MariaDB configuration file
%plesk_dir%DatabasesMySQLmy.iniand add the line
[mysqld]section and save it using text editor:
Restart the MariaDB server (but not "Plesk SQL Server"), running on port 3306 using the Plesk Services Monitor, which can be started from the Windows Start menu.
Note: Plesk Services Monitor could also be started using the next cmd.exe command:
Log into MySQL without the password:
Reload the grant-tables policies by running the next command:
- Update/recreate the user by specifying a new password using the next command:
C:> grant all privileges on *.* to 'admin'@'localhost' identified by 'new_password' with grant option;
Note: Make sure to replace 'new_password' with a new password of choice:
Tell the database server to reload the grant tables by issuing the FLUSH PRIVILEGES command;
skip-grant-tablesfrom the MySQL configuration file(
%plesk_dir%DatabasesMySQLmy.ini) and restart the service again as in Step 3.
Log in to the Plesk interface, go to the database server management settings ( Tools & Settings > Database Servers ) and open the server's settings:
On the opened page click the "Settings" button and specify new the password, that was set in Step 6: