If "root" is access denied (mysql)

Source: http://feeds.feedburner.com/blogspot/Qasmk

Have you ever encountered that after a successful logins to your mysql then the other day you are not able to login anymore using the root account? To fix it, follow below steps for linux users.

1. Stop Mysql

shell> /etc/init.d/mysql stop

2. Start Mysql Safe

shell> mysqld_safe -skip-grant-tables &

3. Start Mysql

shell> /etc/init.d/mysql start

4. Login as root

shell> mysql -u root -p