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

From: Andy Fraser (andyfraser31_at_hotmail.com)
Date: 12/03/04 

Date: Fri, 03 Dec 2004 22:41:34 +0000

In comp.os.linux.setup, Rob uttered these immortal words:

> 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.

Cobblers. None of my MySQL installs have ever had a MySQL root password
that's the same as root's.

> We did not do that. Is there a way to delete the password file
> for mySql and start over?

Have you tried Google? I got
<http://www.google.com/linux?hl=en&lr=&ie=ISO-8859-1&q=reset+mysql+root+password&btnG=Google+Search>.

> 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.

Is MySQL definitely running? Check your configuration if it is. 

-- 
Andy.

Relevant Pages