cant connect to mysql

[mharris]

Hi all

one of our java beans connects to a mysql db. I can connect with the user from commandline mysql, and can verify the permissions in tne mysql.user table.

I get this excetpion when our mdb tries to connect:

08:23:13,622 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access denied for user: '[e-mail]' (Using password: YES))

Ive checked the jboss config files and user/password/port are all correct.

from my mysql

mysql> select host, user from user where user='hashuser';
+-----------------------+----------+
| host | user |
+-----------------------+----------+
| | hashuser |
| localhost.localdomain | hashuser |
+-----------------------+----------+
2 rows in set (0.01 sec)

any idea why jboss cannot connect? Thanx.