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
