centos 5.x - mysql access on localhost denied
 

This is a bit of a weird issue.
I can access the server from remote locations, but not from inside the server itself.

That is to say:
mysql -h hostname.tld -uroot -pWhatever
allows me to log in to the admi console if I do so from any remote machine.

However, if i mysql -uroot -pWhatever
from within the server, it gives me the following error message:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I have granted the root user with access privileges from everywhere:
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'Whatever';
FLUSH PRIVILEGES;

To make matters worse, /etc/my.cnf doesn't specify anythung relevant.

So, in a nutshell, I am locked out inside :(

You can reset the MySQL password as follows: http://www.howtoforge.com/reset-forg...-root-password