-
1. Re: Empty JBoss not connecting to mySQL
luke_t Nov 10, 2003 9:44 AM (in response to gerardg)Can you connect with a simple Java client, using exactly the same connection information?
Luke. -
2. Re: Empty JBoss not connecting to mySQL
gerardg Nov 10, 2003 12:06 PM (in response to gerardg)Good suggestion. No, I cannot and I receive the following:
Exception in thread "main" java.sql.SQLException: Server configuration denies access to data source
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:399)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
at com.mysql.jdbc.Connection.(Connection.java:491)
What are the possible explanations? Where should I look? Any help is greatly appreciated.
gerard -
3. Re: Empty JBoss not connecting to mySQL
gerardg Nov 10, 2003 12:42 PM (in response to gerardg)I've figured out that it is the mySQL grant tables, though I don't understand why, but at least I know what to fix now.
I placed a skip-grant-tables in the config for mySQL , restarted and I can get access to the DB.
Thanks to all for your help.
gerard