I forget my sql root password,where can I find it ?or shoud I reset it


(Lin Cao) #1

I forget mysql root password ,can I find it throug some config file ?or should I only reset it and reinstall my website?

(MD Support) #2

If you know emr user password and it has all grants, you could run

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';

Otherwise you can start mysql in mode without grants check and reset the password.