Oh forgot to ask in the last post, how are you setting the password in the first place? Are you using a grant statement or inserting values into the table. I reckon the former is better (and safer) but if you're doing the later the you need to "flush privliges" after any changes so that mysql rereads the grant tables.
If you can give us the exact line(s) you're putting in then that could help us see the problem (change/mask the password of course). cheers, noel On Tuesday, May 07, 2002 1:44 PM, Noel Clarkson [SMTP:[EMAIL PROTECTED]] wrote: > See that line that says accept any user (%) from any host (%) with password > null. There's your answer. It's a default entry that should be removed (I > think there's stuff in the securing mysql section of the manual about > this). > > cheers > > noel > > On Tuesday, May 07, 2002 1:28 PM, Brandon Metcalf > [SMTP:[EMAIL PROTECTED]] wrote: > > Okay, I'm obviously missing something here. Even though the > > submit_write user has a password set according to the SELECT output > > below, I can't use that password or any password to login as this user. > > Only a null password is accepted. The first attempt I enter the correct > > password; no go. The second attempt I don't enter a password; I'm in. > > > > What gives? > > > > > > mysql> select host,user,password from user mysql; > > +-----------+--------------+------------------+ > > | host | user | password | > > +-----------+--------------+------------------+ > > | localhost | root | 0d7d2b5f41747747 | > > | mccrae | root | 0d7d2b5f41747747 | > > | localhost | | | > > | mccrae | | | > > | % | % | | > > | % | submit_write | 65f6943414e7dad9 | > > | localhost | % | | > > +-----------+--------------+------------------+ > > 7 rows in set (0.01 sec) > > > > mysql> quit > > Bye > > root@mccrae mysql # bin/mysql --user=submit_write --password > > Enter password: > > ERROR 1045: Access denied for user: 'submit_write@localhost' (Using > > password: YES) > > root@mccrae mysql # bin/mysql --user=submit_write --password > > Enter password: > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 76 to server version: 3.23.48 > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > mysql> > > > > > > > > Brandon > > -- > > Beware the fury of a patient man. > > --John Dryden > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
