What to do if you loose your MySQL root password, how to reset it and get everything back to work;
Few Simple steps to change your mysql root password.
- stop MySQL
- start MySQL like the following: mysqld_safe –skip-grant-tables &
You will now be able to login as root into the database without password.
mysql -uroot mysql
On MySQL command line prompt, issue the following command:
UPDATE user SET password=PASSWORD(”yournewpassword”) WHERE user=”root”; FLUSH PRIVILEGES;
Stop MySQL again, and restart it as normal,
You are now able to login to MySQL with your newly specified password
