JDBC error connecting to MySQL

[gdiffor]

I am running a Java application and am trying to access a MySQL database. I continue to get the following error:

Error occurred... java.sql.SQLException: Server configuration denies access to data source

It seems to be knocking me down before it does any user authentication.

Any ideas?

-GD

 

[petersJazz]

This is tricky in mySQL. There is a couple of tables in mySql that controls access to databases and tables, these are columns_priv, db, host, table_priv and user. You have to look in these tables and maybe add some values. If you are trying to access the mysql database from another server you may have to specify the server in db table.