Re: mysql server does not recognize user password

2011-10-19 Thread Reindl Harald
Am 19.10.2011 17:45, schrieb Tim Johnson: > * Reindl Harald [111018 23:24]: >> Am 19.10.2011 01:36, schrieb Tim Johnson: 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 fol

Re: mysql server does not recognize user password

2011-10-19 Thread Tim Johnson
* Reindl Harald [111018 23:24]: > Am 19.10.2011 01:36, schrieb Tim Johnson: > >> 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

Re: mysql server does not recognize user password

2011-10-19 Thread Reindl Harald
Am 19.10.2011 01:36, schrieb Tim Johnson: >> 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.. then your mysql CLIENT is broken or somehow

Re: mysql server does not recognize user password

2011-10-18 Thread Claudio Nanni
sql@lists.mysql.com > > Sent: Wednesday, 19 October, 2011 3:53:23 AM > > Subject: Re: mysql server does not recognize user password > > > > Why does mysql say "using password: no"? Seems to me the password is > > not > > being sent. > > > > On

Re: mysql server does not recognize user password

2011-10-18 Thread Johan De Meersman
t; > Cc: mysql@lists.mysql.com > Sent: Wednesday, 19 October, 2011 3:53:23 AM > Subject: Re: mysql server does not recognize user password > > Why does mysql say "using password: no"? Seems to me the password is > not > being sent. > > On Oct 18, 2011 8:37

Re: mysql server does not recognize user password

2011-10-18 Thread Johnny Withers
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" wrote: * Claudio Nanni [111018 17:02]: > FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER > etc, > > Usually this ... linus:~ tim$ sudo mysql Pas

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
* Tim Johnson [111018 17:47]: Got this... mysql> select host,user,password from user; +-+--+---+ | host| user | password | +-+--+---+ | localho

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
* Claudio Nanni [111018 17:02]: > FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER > etc, > > Usually this problem comes when you have the anonymous user in the grant > tables (''), > MySQL has a tricky way of processing the grant tables. > > Sometimes you can be surprise

Re: mysql server does not recognize user password

2011-10-18 Thread Claudio Nanni
FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER etc, Usually this problem comes when you have the anonymous user in the grant tables (''), MySQL has a tricky way of processing the grant tables. Sometimes you can be surprised by what you read issuing: SELECT USER(),CURREN

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
* Reindl Harald [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'@'

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
* Mark [111018 15:14]: > Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session? Not originally, but I repeated the grant then issued flush privileges; quit and have the same problem thanks -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebs

Re: mysql server does not recognize user password

2011-10-18 Thread 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

RE: mysql server does not recognize user password

2011-10-18 Thread Mark
Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session? - Mark -Original Message- From: Tim Johnson [mailto:t...@akwebsoft.com] Sent: woensdag 19 oktober 2011 1:02 To: MySQL ML Subject: mysql server does not recognize user password using 5.1.57 on Mac Lion. I've done t