buy tb500

Archive for March, 2017

reset the MySQL administrator’s password (Windows)

Tuesday, March 21st, 2017

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-