MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Posted by: Matthew Wierzgac
Date: May 11, 2006 08:59PM

getting same thing...

I installed MySQL 5.0 onto my Debian Sarge 3.1 box. After Installation, it automatically started the server.. That being said, I set a pw for the root user:
/usr/bin/mysqladmin -u root password 'newpassword'
/usr/bin/mysqladmin -u root -h www password 'newpassword'

Now obviously i substituted 'newpassword' with a pw that i desired. And www is the host address. Now when i do a mysql -u root i get this

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I even did the --skip-grant-tables option when i restarted the dameon, and tried resetting the root password, and get the same results.. I can connect if i specify a -p 'mypassword', however I dont want to have to specify a pw every single time i issue a mysql command under root, even to view the status..... Can someone plz point me in the right direction on how to resolve this issue??

Edited 1 time(s). Last edit at 05/11/2006 09:01PM by Matthew Wierzgac.

Options: ReplyQuote

Written By
June 27, 2009 08:29PM
December 16, 2007 02:18AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
May 11, 2006 08:59PM
December 27, 2007 02:08PM
January 16, 2011 06:51AM
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.