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

[Paul Lewis <paul.lewis@quadensemble.co.uk>]

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