buy tb500

reset the MySQL administrator’s password (Windows)

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.

password should be reset already and no more issues

 

Reference

https://support.plesk.com/hc/en-us/articles/213947045-How-to-reset-the-MySQL-administrator-s-password-Windows-

Leave a Reply