Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 25th March 2012, 21: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
 

Bookmarks

Tags
centos, localhost, mysql, root

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
DBI connect failed : Access denied for user 'root'@'%' to database 'mysql' kwickcut Technical 3 11th February 2012 12:48
Postfix doesn't have Nolan Installation/Configuration 5 13th April 2011 05:00
maildrop : user unknown. Command output: Invalid user specified. mfrna Server Operation 4 20th May 2010 09:50
Mail errors unknown address terryoleary1981 General 9 10th January 2008 16:51
External Email Getting Lost jash General 10 8th November 2005 21:55


All times are GMT +2. The time now is 16:35.


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