How to reset the MySQL administrator's password on Plesk server

[Yusuf]

If you forget the Mysql server password, you can reset it, using the below steps:

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

2. Edit the MySQL configuration file, %plesk_dir%\Databases\MySQL\Data\my.ini (or your installation path), 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"

To change the password for the MySQL administrator run the below 2 commands in the MySQL console:

UPDATE mysql.user SET Password = password('newpassword') WHERE User = 'admin';
flush privileges;

5. Remove skip-grant-tables from the MySQL configuration file and restart the service.

6. 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 4, Plesk will re-establish the connection to the server.

Regards,
Yusuf M

[Colin-B]

Re: How to reset the MySQL administrator's password on Plesk server

Thankyou for step by step info, basic and vital