MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Posted by: Felix Bowman
Date: April 03, 2008 03:14AM

From what I've noticed with MySQL 5.0.51 and up, if you're trying to login with an account other than root that you have a password set for and you try it with host set as localhost, it will not work. If you don't specify a password, it will log you in.

On the other hand, it works as intended if your host is set as 127.0.0.1

I'm not sure if the functionality changed and I missed it or if this is a bug.

Options: ReplyQuote


Subject
Written By
Posted
June 27, 2009 08:29PM
December 16, 2007 02:18AM
December 27, 2007 02:08PM
January 16, 2011 06:51AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
April 03, 2008 03:14AM
August 27, 2009 12:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.