* Reindl Harald <h.rei...@thelounge.net> [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 servers. > > 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 tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org