From: Claudio Nanni Date: October 19 2011 6:24am Subject: Re: mysql server does not recognize user password List-Archive: http://lists.mysql.com/mysql/226098 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016361e81d8d65f3c04afa0e59e --0016361e81d8d65f3c04afa0e59e Content-Type: text/plain; charset=ISO-8859-1 mysql -utim Then mysql> SELECT USER(),CURRENT_USER(); Login as root and: delete from mysql.user where user=''; And try again with tim with password. Thanks Claudio On Oct 19, 2011 7:47 AM, "Johan De Meersman" wrote: > Try not passing the password and typing it at the prompt. If that works, > there's a problem in the parameter parsing. > > Random thought: could you have a .my.cnf file in your home directory? > > ----- Original Message ----- > > From: "Johnny Withers" > > To: "Tim Johnson" > > Cc: mysql@stripped > > 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 PM, "Tim Johnson" wrote: > > > > > > linus:~ tim$ sudo mysql > > Password: > > ..... > > mysql> SELECT USER(),CURRENT_USER(); > > +----------------+----------------+ > > > > +----------------+----------------+ > > > > +----------------+----------------+ > > > > 1 row in set (0.00 sec) > > ...hmm... on my linux box, where all works, I see > > 'tim@localhost' > > > > > > linus:~ tim$ mysql -utim -p****** -h127.0.0.1 -P3306 > > > > ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using > > password: NO) > > Thanks. > > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=claudio.nanni@stripped > > --0016361e81d8d65f3c04afa0e59e--