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.
Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 26th March 2012, 13:35
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,744 Times in 2,577 Posts
Default

You can reset the MySQL password as follows: http://www.howtoforge.com/reset-forg...-root-password
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

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 21:01.


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