User Access Question

Hi All,

I'm running MySQL 4.1 on a Win2k box and I'm confused (again) about user
logins.  My application is getting the following error:

Connection verification failed for data source: MySQLDSN
[]java.sql.SQLException: Access denied for user 'admin'@'host.mydomain.net'
(using password: YES)
The root cause was that: java.sql.SQLException: Access denied for user
'admin'@'host.mydomain.net' (using password: YES)

Here is the contents of my user table:

host                             user
%                                 admin
localhost                      admin
localhost                      root
host.mydomain.net      admin

Clearly 'admin'@'host.mydomain.net' has access.  Yet, I'm getting this
error.  The strange thing is, I can connect via SQL Manager for MySQL using
an "admin" login.  So, the 'admin'@'%' is working.  What am I doing wrong?


--
"Liberalism is trust of the people, tempered by prudence; conservatism,
distrust of the people, tempered by fear."
-William Gladstone
------------------------------------------
Robert Nurse
http://www.bajansrealm.com
AIM: BarbadosToNYC