List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:October 19 2011 6:24am
Subject:Re: mysql server does not recognize user password
View as plain text  
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" <vegivamp@stripped> 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" <johnny@stripped>
> > To: "Tim Johnson" <tim@stripped>
> > 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" <tim@stripped> 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=1
>
>

Thread
mysql server does not recognize user passwordTim Johnson19 Oct
  • RE: mysql server does not recognize user passwordMark19 Oct
    • Re: mysql server does not recognize user passwordTim Johnson19 Oct
  • Re: mysql server does not recognize user passwordReindl Harald19 Oct
    • Re: mysql server does not recognize user passwordTim Johnson19 Oct
      • Re: mysql server does not recognize user passwordClaudio Nanni19 Oct
        • Re: mysql server does not recognize user passwordTim Johnson19 Oct
          • Re: mysql server does not recognize user passwordTim Johnson19 Oct
          • Re: mysql server does not recognize user passwordJohnny Withers19 Oct
            • Re: mysql server does not recognize user passwordJohan De Meersman19 Oct
              • Re: mysql server does not recognize user passwordClaudio Nanni19 Oct
      • Re: mysql server does not recognize user passwordReindl Harald19 Oct
        • Re: mysql server does not recognize user passwordTim Johnson19 Oct
          • Re: mysql server does not recognize user passwordReindl Harald19 Oct