​ 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