Reset mysql password without login into it
I had installed phpmyadmin in ubuntu 11.10. But I can’t login into it cause I forgot password of mysql.
After a little search I found the way to reset password without login into it. It need only root access of machine. I just like to share it
Follow the below steps to reset password of mysql.
1. Stop MySQL Server.
sudo /etc/init.d/mysql stop
2. Start the mysqld configuration.
sudo mysqld –skip-grant-tables &
3. Login to MySQL as root.
mysql -u root mysql
4. Replace NEWPASSWORD with your new password!
UPDATE user SET Password=PASSWORD(‘NEWPASSWORD’) WHERE User=’root’; FLUSH PRIVILEGES;