Fwd: Access denied for user 'root'@'localhost' in mysql

[Bernard Fay <xi@videotron.ca>]

---------- Forwarded message ----------
From: Bernard Fay <xi@videotron.ca>
Date: Wed, Jun 3, 2009 at 5:00 PM
Subject: Re: Access denied for user 'root'@'localhost' in mysql
To: paul.lewis@quadensemble.co.uk


Thanks for your reply, Paul.

Yes, I tried without the -p switch and it didn't work.

Also, I just found that in mysql.user there is no host:localhost and user:root but I have host:beryllium and user:root; beryllium being my hostname.

Maybe we have something here.

Bern

On Wed, Jun 3, 2009 at 4:45 PM, Paul Lewis <paul.lewis@quadensemble.co.uk> wrote:

On 03/06/09 20:58:45, Bernard Fay wrote:

Hi,

I installed MySQL in Lenny.
When I try to login in with mysql -u root -p, I receive :

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

I wonder if there is a password defined before you set the root password in mysql yourself? I think not. Try connecting without th -p switch.

Any idea or clues about how to solve this issue?

Thanks,
Bernard

Otherwise, have a look here.

http://dev.mysql.com/doc/refman/5.1/en/connection-access.html



--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.orgwith a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org