How to Reset MySQL Admin Password via Windows Plesk

How to Reset MySQL Admin Password in Windows Plesk

Once you have logged into your server via Remote Desktop you need to take the following steps:

  1. Go to “Start” >> “Run”. Enter “services.msc”.
  2. Search for ‘MySql Server’ in the “Services” window.
  3. Right click on “MySql Server”. Go to “Properties”.
  4. Once “my.ini” is copied go to “Start” >> “Run”. Enter the location of the “my.ini” file.
  5. C:\Program Files\SWsoft\Plesk\Databases\MySQL\Data\my.ini

  6. Under “[mysqld]” in “my.ini”, add the following line:
  7. skip-grant-tables
  8. Restart “MySql Server”.
  9. Login to MySql:
  10. cd C:\Program Files\SWsoft\Plesk\MySQL\bin
    C:\Program Files\SWsoft\Plesk\MySQL\bin>mysql -u admin
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 7 to server version: 4.1.18-nt
    
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    
    
    mysql> use mysql;
    mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='admin';
    mysql> FLUSH PRIVILEGES;
    mysql> quit;
  11. Remove “skip-grant-tables” from the “my.ini” file. Restart “MySql” after re-saving the “my.ini” file.

Ralph Gervolino

Leave a Reply