Reset your password in MySQL (mysql)


There are times when you forget your password and if it is from mysql it really suck!
No worries if you run your mysql system.

For linux users I have the following command lines try them will work:

Stop the MySQL Server.
sudo /etc/init.d/mysql stop

Start the mysqld configuration.
sudo mysqld –skip-grant-tables &

Login to MySQL as root.
mysql -u root mysql

Replace YOURNEWPASSWORD with your new password!
UPDATE user SET Password=PASSWORD(‘YOURNEWPASSWORD’) WHERE User=’root’; FLUSH PRIVILEGES; exit;

Enjoy🙂