ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES)

2004-05-24 Thread Jack Woehr
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

Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES)

2004-05-24 Thread Michael Stassen
Jack Woehr 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

Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES)

2004-05-24 Thread Egor Egorov
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

Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES) SOLVED

2004-05-24 Thread Jack Woehr
I figured this out. It's the ANY setup in Privileges. Being set to allow ANY user to login without password, MySQL interestingly interprets that as even known users with passwords MUST log in without passwords. My two solutions were either to delete the ANY privileges or to create a second

Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES) SOLVED

2004-05-24 Thread Michael Stassen
Jack Woehr wrote: I figured this out. It's the ANY setup in Privileges. Being set to allow ANY user to login without password, MySQL interestingly interprets that as even known users with passwords MUST log in without passwords. Well, that seems to be the effect, but that's not what it is doing.