reset the MySQL administrator’s password (Windows)
Resolution
To solve the problem and reconnect Plesk with the MySQL server, follow these steps:
- Stop the MySQL server (but not “Plesk SQL Server”) from running on port 3306 using the Plesk Services Monitor tray utility.
- Edit the MySQL configuration file,
%plesk_dir%\\Databases\\MySQL\\Data\\my.ini
, and add the lineskip-grant-tables
to the[mysqld]
section. - Start the MySQL server.
- 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-