FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
Usually this problem comes when you have the anonymous user in the grant
MySQL has a tricky way of processing the grant tables.
Sometimes you can be surprised by what you read issuing:
mysql -utim -psecret -h127.0.0.1 -P3306
2011/10/19 Tim Johnson <tim@stripped>
> * Reindl Harald <h.reindl@stripped> [111018 15:14]:
> > 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"?
> Second time around, yes. Same problem
> > you do not specify any password from the view of the server it seems
> ("using password: NO")
> I am using the same syntax I use on my current machine, but your
> observation appears correct, mysql is _not_ seeing my password.
> > try "mysql -u tim -p"
> Same error:
> ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using
> password: NO)
> > and enter yur password in the followed dialog
> Doesn't even ask for the pwd..
> > passwords in command-lines are really bad bacause they are in the
> processlist and history
> I'm not concerned. Am closed to the outside world - these are not
> > > If I login into the server as root again:
> > > linus:~ tim$ sudo mysql
> > > mysql> show grants for tim@localhost;
> > root without a password?
> > jokingly
> Yup. It's been years since I set up mysql. I know I've missed
> something, but don't know what.
> thank you
> tim at tee jay forty nine dot com or akwebsoft dot com
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: