HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)
-   -   centos 5.x - mysql access on localhost denied (http://www.howtoforge.com/forums/showthread.php?t=56680)

nzimas 25th March 2012 21:12

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 :(

falko 26th March 2012 13:35

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 04:53.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.