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