How to reset the MySQL administrator's password (Windows)

Created:

2016-11-16 13:14:51 UTC

Modified:

2017-02-24 14:59:01 UTC

1

Was this article helpful?


Have more questions?

Submit a request

How to reset the MySQL administrator's password (Windows)

Symptoms

Attempts to manage a customer's MySQL databases produce errors:

Error: Connection to the database server has failed because of network problems: Try to establish connection failed

The MySQL server is marked in red on the Tools & Settings > Database Servers screen.

Cause

This problem may be caused by Plesk storing an incorrect MySQL server administrator password.

Resolution

To solve the problem and reconnect Plesk with the MySQL server, follow these steps:

  1. Stop the MySQL server (but not "Plesk SQL Server") from running on port 3306 using the Plesk Services Monitor tray utility.

  2. Edit the MySQL configuration file, %plesk_dir%\\Databases\\MySQL\\Data\\my.ini , and add the line skip-grant-tables to the [mysqld] section.

  3. Start the MySQL server.

  4. Log into MySQL without the password:

    "%plesk_dir%\\Databases\\MySQL51\\bin\\mysql.exe"
  5. Change the password for the MySQL administrator:

    UPDATE mysql.user SET Password = password('newpassword') WHERE User = 'admin';
  6. Remove skip-grant-tables from the MySQL configuration file and restart the service.

  7. Log into 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.

For the same problem on a Linux server, please use this article

Have more questions? Submit a request
Please sign in to leave a comment.