ARGGH! - User password problems

[Adam Fortuno KOVICK]

--Boundary_(ID_B/b4ffTtDNz/xCjv2UIigg)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
Content-disposition: inline

All,

I've been attempting to assign a password to a user with the following
statement:

UPDATE mysql.user SET password=PASSWO RD('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: 'a*******@192.1 68.0.3' (Using password: NO)

HELP before I lose my mind and start pretending I am a glass of orange
juice.

Regards,
Adam
--Boundary_(ID_B/b4ffTtDNz/xCjv2UIigg)
Content-Type: text/plain; charset=us-ascii

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw
--Boundary_(ID_B/b4ffTtDNz/xCjv2UIigg)--