How reset mysql root password ??

To reset the password

Follow these steps (can be helpful if you really forget your password and you can try it anytime, even if you're not in the situation at the moment):

1. Stop mysql

   sudo /etc/init.d/mysql stop

   or for other distro versions

   sudo /etc/init.d/mysqld stop

2. Start MySQL in safe mode

   sudo mysqld_safe --skip-grant-tables &

3. Log into MySQL using root

   mysql -uroot

4. Select the MySQL database to use

   use mysql;

5. Reset the password

   update user set password=PASSWORD("mynewpassword") where User='root';

6. Flush the privileges

   flush privileges;

7. Restart the server

   quit

8. Stop and start the server again
   ubuntu and debian

   sudo /etc/init.d/mysql stop
   ...
   sudo /etc/init.d/mysql start

   On CentOS and Fedora and RHEL

   sudo /etc/init.d/mysqld stop
   ...
   sudo /etc/init.d/mysqld start

9. Login with new password

   mysql -u root -p

10. Type new password and enjoy your server again like nothing happened