View Single Post
  #1  
Old 25th March 2012, 22:12
nzimas nzimas is offline
Member
 
Join Date: May 2007
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation 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
Reply With Quote
Sponsored Links