All,
I've been attempting to assign a password to a user with the following
statement:
UPDATE mysql.user SET password=PASSWORD('foo') WHERE user = 'acc_name';
I get the typical:
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
However, when the user attempts the login using the password they are
unable (access is denied to acc_name with password yes). If they
attempt to login without a password, they are successful - WTF!.
There is only 1-entry in the user table for this user so I didn't
specify a host.
Next, for the same user account, if I try to login from a remote
machine (via ODBC) I am denied access (event with the blank password!).
The user has the following host '%' (no other hosts present), yet I
receive an error that reads:
Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
HELP before I lose my mind and start pretending I am a glass of orange
juice.
Regards,
Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
