0 Replies Latest reply on Sep 22, 2005 5:17 PM by Michael Harris

    cant connect to mysql

    Michael Harris Newbie

      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))

      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.