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]
