List:General Discussion« Previous MessageNext Message »
From:Mark Date:October 18 2011 11:05pm
Subject:RE: mysql server does not recognize user password
View as plain text  
Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session?

- Mark



-----Original Message-----
From: Tim Johnson [mailto:tim@stripped] 
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.
<blush> I've done this a dozen times, but I've missed something.
Am setting up a new mysql installation ...
I have granted a user as follows (between lines of asterisks)
************************************************************
linus:~ tim$ sudo mysql
Password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.1.57 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software, and
you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> use mysql;
Reading table information for completion of table and column names You can
turn off this feature to get a quicker startup with -A

Database changed
mysql> GRANT ALL PRIVILEGES ON *.* TO 'tim'@'localhost' IDENTIFIED BY 
mysql> 'secret'  WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> quit;
Bye
************************************************************
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!
If I login into the server as root again:
linus:~ tim$ sudo mysql
mysql> show grants for tim@localhost;
+---------------------------------------------------------------------------
------------------------------------------------------------+
| Grants for tim@localhost
|
+---------------------------------------------------------------------------
------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'tim'@'localhost' IDENTIFIED BY 
| PASSWORD '*E8482E479FD05E800263C26A724513BBBFAA108B' WITH GRANT OPTION 
| |
+---------------------------------------------------------------------------
------------------------------------------------------------+
1 row in set (0.00 sec)
It appears that the user is there.
Is there a difference in the syntax with this version for providing the
password?
If I try
mysql -h localhost -u tim -p
I get
ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using
password: NO) just as in the example above.
Have I forgotten to do something in the setup?

TIA
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com

--
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