- Plesk for Windows
Note: This article is related to MySQL user's databases server on Windows. Not the Plesk SQL one. Plesk interface should be accessible.
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.
Stop the MariDB server (but not "Plesk SQL Server") from running on port 3306 using the Plesk Services Monitor, which can be started from the Windows Start menu.
Edit the MariaDB configuration file
%plesk_dir%Databases\MySQL\my.iniand add the line
[mysqld]section and save it using text editor:
Start the MariaDB server using the Plesk Services Monitor.
Log into MySQL without the password:
Change the password for the MySQL administrator:
For MySQL 5.7.6 and newer as well as MariaDB 10.1.20 and newer, use the following command:
ALTER USER 'admin'@'localhost' IDENTIFIED BY 'new_password';
For MySQL 5.7.5 and older as well as MariaDB 10.1.20 and older, use:
SET PASSWORD FOR 'admin'@'localhost' = PASSWORD('new_password');
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;
If there is no user "admin" in MySQL:
mysql> ALTER USER 'admin'@'localhost' IDENTIFIED BY 'new_password';
Query OK, 0 rows affected (0.00 sec) <-- No user "admin" found
Create the admin user and grant all privileges:
mysql>CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';
mysql>GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
skip-grant-tablesfrom the MySQL configuration file and restart the service.
Log in to the Plesk interface, go to the database server management settings ( Tools & Settings > Database Servers ), and change the password for the corresponding database server to the one set in Step 5. Plesk will re-establish the connection to the server.
Note: in some rare cases step 6 may not work and the following procedure can be used for the admin user How to Reset the Root Password. Make sure the commands are adapted for the admin user.