Why does mysql say "using password: no"? Seems to me the password is not being sent.
On Oct 18, 2011 8:37 PM, "Tim Johnson" <t...@akwebsoft.com> wrote: * Claudio Nanni <claudio.na...@gmail.com> [111018 17:02]: > FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER > etc...., > > Usually this ... linus:~ tim$ sudo mysql Password: ..... mysql> SELECT USER(),CURRENT_USER(); +----------------+----------------+ | USER() | CURRENT_USER() | +----------------+----------------+ | root@localhost | root@localhost | +----------------+----------------+ 1 row in set (0.00 sec) ...hmm... on my linux box, where all works, I see 'tim@localhost' > try this: > > mysql -utim -psecret -h127.0.0.1 -P3306 linus:~ tim$ mysql -utim -p****** -h127.0.0.1 -P3306 ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO) Thanks. -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL ... To unsubscribe: http://lists.mysql.com/mysql?unsub=joh...@pixelated.net