I'm having a problem similar to the one mentioned in the list message
http://lists.mysql.com/mysql/165952
* I built, installed, and run MySQL 4.0.18
o gcc 2.95.3 on Solaris 9
* I created a user "abcd" and used MyPHPAdmin to give this user a password
"xxyyzzaa"
* I can login using the command-line 'mysql -u abcd'
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
* As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have
verified the password field for 'abcd' was instantiated.
Can anyone inform me how to cause MySQL to use passwords? Thank you.
--
Jack J. Woehr # "[F]ar in the empty sky a solitary esophagus slept
http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness,
http://www.softwoehr.com # serenity, and the peace of God." - Mark Twain
