Reset the MySQL root password on Ubuntu Linux

Do you know you can easily reset your mysql root passowrd...

Follow below steps to reset your password,type the following commands in your terminal

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 YOURNEWPASSWORD with your new password!

UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;

5)start your mysql server