I forget mysql root password ,can I find it throug some config file ?or should I only reset it and reinstall my website?
lin (Lin Cao) #1
mdsupport (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.