Access denied for user 'root'@'localhost' (using password: NO) - The cure

Sometimes you cant log into the mysql in root mode:

bash-2.03# /usr/local/mysql/bin/mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

The cure (what to do in that case)

In that case try to log in with host name :

/usr/local/mysql/bin/mysql -h 172.16.80.63 -uroot and you might have permissions to do all you want.
or even try : [root@mas2qa root]# /usr/local/mysql/bin/mysql -ulocalhost.localadmin