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" <vegiv...@tuxera.be> 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" <joh...@pixelated.net> > > To: "Tim Johnson" <t...@akwebsoft.com> > > 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 PM, "Tim Johnson" <t...@akwebsoft.com> 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.na...@gmail.com > >
