List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:October 19 2011 1:53am
Subject:Re: mysql server does not recognize user password
View as plain text  
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:

* Claudio Nanni <claudio.nanni@stripped> [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=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