Jack Woehr <[EMAIL PROTECTED]> wrote: > > 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'
Seems you connected as anonymous user. Check it with SELECT CURRENT_USER() function. > * 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. > Connect as a root and delete from table mysql.user entry for user ''@'localhost'. Then execute FLUSH PRIVILEGES command. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]