Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)

From: Rob (newsgroup_at_marine.com)
Date: 12/03/04 

Date: Fri, 03 Dec 2004 17:29:24 -0500

Andy,

Yes, even if I change, config.inc.php login from auth to http and get
prompted for a pwd it does not accept it. I think the problem was that
when we first got phpMyAdmin up it warned us to set a pwd for root and
we set it to something other that the machine root pwd. My
understanding is that the pwd should be the same for mySql as for linux
root. We did not do that. Is there a way to delete the password file
for mySql and start over? We've tried:

  mysqladmin -u root flush-privileges password "newpwd"

but get another error message:

#2002 - Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)

The file mysql.sock is not there when I go to look for it.

Any ideas?

Thanks.

Rob

Andy Fraser wrote:
> In comp.os.linux.setup, Rob uttered these immortal words:
>
>
>>Trying to login to phpMyAdmin and I get:
>>
>>#1045 - Access denied for user 'root'@'localhost' (using password: NO)
>>
>>Anyone know how to fix this?
>
>
> That's an error from MySQL not phpMyAdmin. It looks like you didn't enter a
> password when trying to login. If you did enter a password you're going to
> have to give more information.
> 

-- 
Rob Proctor
Marine.com & Cyber-Marine.com
<robp@marine.com>
602 Blue Hills Road
Durham
CT
06422
USA
Cellular: 860-214-0278
Fax: 928-962-1049
Toll Free: 800-597-1781
Work:  860-349-9499

Relevant Pages