reset the MySQL administrator’s password (Windows)


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:



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.

password should be reset already and no more issues



Leave a Reply