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

installation

(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';
FLUSH PRIVILEGES;

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