Changing MySQL password

[Plesk_kidv]

Hello,

Can someone please tell me how to change the MySQL database password without having the old password. Need to connect Plesk to the local MySQL server but the password I have is incorrect.

thanks for your help

 

[Plesk_kidv]

I figured it out . In case anyone needs this

Step 1. Go to C:\Program Files\Parallels\Plesk\Databases\MySQL\Data\my.ini and add the following line: 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:

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