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';
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
|All times are GMT +2. The time now is 06:30.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.