It happens from time to time. For me, it happens after being on a long vacation. I forget my password, and the root password. Shame on me. Recovering is simpler than you think!
- Open console and stop mysql service
#/etc/init.d/mysqld stop - Then i run this service without password
#mysqld_safe --skip-grant-tables
You can also run it as a background if you would not use another console (shell)#mysqld_safe --skip-grant-tables & - Then i open another console and connect to mysql
#mysql -u root output mysql> - Next, i setup new password for root user
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit - Last step is stop mysql service
#/etc/init.d/mysqld stop - Finish, and start mysqld and test new password
#/etc/init.d/mysqld start #mysql -u root -p