Re: mysql server does not recognize user password
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
Re: mysql server does not recognize user password
Am 19.10.2011 01:36, schrieb Tim Johnson: try mysql -u tim -p Same error: ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO) and enter yur password in the followed dialog Doesn't even ask for the pwd.. then your mysql CLIENT is broken or somehow misconfigured or overwritten with a dumb alias what says which mysql? the password-propmt is coming from the client long before any connect would be tried and so you will be prompted even the server is down signature.asc Description: OpenPGP digital signature
Re: mysql server does not recognize user password
* Reindl Harald h.rei...@thelounge.net [111018 23:24]: Am 19.10.2011 01:36, schrieb Tim Johnson: try mysql -u tim -p Same error: ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO) and enter yur password in the followed dialog Doesn't even ask for the pwd.. then your mysql CLIENT is broken or somehow misconfigured or overwritten with a dumb alias what says which mysql? blush you nailed it! Thank you. mysql $1 $2 ## where is $3? I've been trying to think of a way of covering up this dumb mistake, but I'm just going to come out and say it. I'd set up this quick and dirty script (because at the time, being new to the OS, couldn't figure out how to do a proper alias or symlink) and forgot about it duh! thanks again for all the help. I actually learned some new tricks from you folks! regards -- 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=arch...@jab.org
Re: mysql server does not recognize user password
Am 19.10.2011 17:45, schrieb Tim Johnson: * Reindl Harald h.rei...@thelounge.net [111018 23:24]: Am 19.10.2011 01:36, schrieb Tim Johnson: try mysql -u tim -p Same error: ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO) and enter yur password in the followed dialog Doesn't even ask for the pwd.. then your mysql CLIENT is broken or somehow misconfigured or overwritten with a dumb alias what says which mysql? blush you nailed it! Thank you. mysql $1 $2 ## where is $3? I've been trying to think of a way of covering up this dumb mistake, but I'm just going to come out and say it. I'd set up this quick and dirty script (because at the time, being new to the OS, couldn't figure out how to do a proper alias or symlink) and forgot about it ~/.bashrc [root@buildserver:~]$ which mysql alias mysql='/usr/bin/mysql -p' /usr/bin/mysql signature.asc Description: OpenPGP digital signature
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 '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=arch...@jab.org
RE: mysql server does not recognize user password
Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session? - Mark -Original Message- From: Tim Johnson [mailto:t...@akwebsoft.com] 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=ad...@asarian-host.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql server does not recognize user password
Am 19.10.2011 01:03, schrieb Tim Johnson: 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! did you make flush privileges? you do not specify any password from the view of the server it seems (using password: NO) try mysql -u tim -p and enter yur password in the followed dialog passwords in command-lines are really bad bacause they are in the processlist and history If I login into the server as root again: linus:~ tim$ sudo mysql mysql show grants for tim@localhost; root without a password? jokingly signature.asc Description: OpenPGP digital signature
Re: mysql server does not recognize user password
* Mark ad...@asarian-host.net [111018 15:14]: Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session? Not originally, but I repeated the grant then issued flush privileges; quit and have the same problem thanks -- 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=arch...@jab.org
Re: mysql server does not recognize user password
* Reindl Harald h.rei...@thelounge.net [111018 15:14]: Am 19.10.2011 01:03, schrieb Tim Johnson: 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! did you make flush privileges? Second time around, yes. Same problem you do not specify any password from the view of the server it seems (using password: NO) I am using the same syntax I use on my current machine, but your observation appears correct, mysql is _not_ seeing my password. try mysql -u tim -p Same error: ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO) and enter yur password in the followed dialog Doesn't even ask for the pwd.. passwords in command-lines are really bad bacause they are in the processlist and history I'm not concerned. Am closed to the outside world - these are not servers. If I login into the server as root again: linus:~ tim$ sudo mysql mysql show grants for tim@localhost; root without a password? jokingly Yup. It's been years since I set up mysql. I know I've missed something, but don't know what. thank you -- 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=arch...@jab.org
Re: mysql server does not recognize user password
FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER etc, Usually this problem comes when you have the anonymous user in the grant tables (''), MySQL has a tricky way of processing the grant tables. Sometimes you can be surprised by what you read issuing: SELECT USER(),CURRENT_USER(); try this: mysql -utim -psecret -h127.0.0.1 -P3306 Regards Claudio 2011/10/19 Tim Johnson t...@akwebsoft.com * Reindl Harald h.rei...@thelounge.net [111018 15:14]: Am 19.10.2011 01:03, schrieb Tim Johnson: 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! did you make flush privileges? Second time around, yes. Same problem you do not specify any password from the view of the server it seems (using password: NO) I am using the same syntax I use on my current machine, but your observation appears correct, mysql is _not_ seeing my password. try mysql -u tim -p Same error: ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO) and enter yur password in the followed dialog Doesn't even ask for the pwd.. passwords in command-lines are really bad bacause they are in the processlist and history I'm not concerned. Am closed to the outside world - these are not servers. If I login into the server as root again: linus:~ tim$ sudo mysql mysql show grants for tim@localhost; root without a password? jokingly Yup. It's been years since I set up mysql. I know I've missed something, but don't know what. thank you -- 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=claudio.na...@gmail.com -- Claudio
Re: mysql server does not recognize user password
* Claudio Nanni claudio.na...@gmail.com [111018 17:02]: FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER etc, Usually this problem comes when you have the anonymous user in the grant tables (''), MySQL has a tricky way of processing the grant tables. Sometimes you can be surprised by what you read issuing: SELECT USER(),CURRENT_USER(); 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql server does not recognize user password
* Tim Johnson t...@akwebsoft.com [111018 17:47]: Got this... mysql select host,user,password from user; +-+--+---+ | host| user | password | +-+--+---+ | localhost | root | | | linus.local | root | | | 127.0.0.1 | root | | | localhost | | | | linus.local | | | | localhost | tim | *E8482E479FD05E800263C26A724513BBBFAA108B | | linus | tim | *E8482E479FD05E800263C26A724513BBBFAA108B | +-+--+---+ 7 rows in set (0.00 sec) -- 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=arch...@jab.org
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: * Claudio Nanni claudio.na...@gmail.com [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=joh...@pixelated.net
Re: mysql server does not recognize user password
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=arch...@jab.org