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: 'hashuser@localhost.localdomain' (Using password: YES))
mysql> select host, user from user where user='hashuser'; +-----------------------+----------+ | host | user | +-----------------------+----------+ | | hashuser | | localhost.localdomain | hashuser | +-----------------------+----------+ 2 rows in set (0.01 sec)