More

    Change root MySQL password in Windows/Plesk

    This article covers how to change root mysql password in Windows/Plesk.

    Step 1.  Go to C:\Program Files\Parallels\Plesk\Databases\MySQL\Data\my.ini  and add the following line at the top:

    skip-grant-tables

    (this will let you access MySQL with no password)

     

    Step 2.  Restart MySQL

     

    Step 3.  Open CMD and change to the directory   C:\Program Files\Parallels\Plesk\Databases\MySQL\bin\

     

    Step 4. Go into the MySQL command utility, (notice you are not using a password):

    mysql -u root mysql

     

    Step 5. Change the password using these two  commands

    mysql>  UPDATE mysql.user SET Password=PASSWORD(‘New_Pass_Word’) WHERE User=’root’;

    mysql>   FLUSH PRIVILEGES;

    (New_Pass_Word  is the new password you would like to use )

    (if the root user doesn’t work when updating the password in Plesk try changing the user from ‘root’ to ‘admin’ in the command above)

     

    Step 6. Restart mysql

     

    Step 7. Go into Plesk and update the MySQL password to the changed

     

    Step 8. Remove the line ‘skip-grant-tables’ from the my.ini file and restart mysql

    Recent Articles

    spot_img

    Related Stories

    Stay on op - Ge the daily news in your inbox