Hi Did you remember to flush???
----- Original Message ----- From: "Adam Fortuno KOVICK" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: July 31, 2003 4:33 PM Subject: ARGGH! - User password problems > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]