How To: MySQL Error "Access denied for user..."

[lnxcode]

Are you getting ?

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

How do you fix the above?

From SSH, you will do the below commands:

• service chkservd stop
• service mysql stop
• vi /mysql.recover

• #add the following line to /mysql.recover and change MyNewPassword to the password that you want

• SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
• chmod 777 /mysql.recover
• mysqld_safe --init-file=/mysql.recover &
• service mysql stop
• rm -fv /mysql.recover
• service mysql start
• service chkservd start
• the root pass is in /root/.my.cnf

You should be all set!