Re: mysql server does not recognize user password

[Reindl Harald]

Am 19.10.2011 01:03, schrieb Tim Johnson:
> Now when I try to log in with host as localhost, user as tim
> with 'secret' password:
> linus:~ tim$ mysql --host=localhost --user=tim --password=secret
> ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO)
> Huh!

did you make "flush privileges"?
you do not specify any password from the view of the server it seems ("using password:
NO")

try "mysql -u tim -p"
and enter yur password in the followed dialog
passwords in command-lines are really bad bacause they are in the processlist and history

> If I login into the server as root again:
> linus:~ tim$ sudo mysql
> mysql> show grants for tim@localhost;

root without a password?
jokingly


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc