Tomcat not able to access MySQL DBs

[brundle]

I have Tomcat installed along with DA. A MySQL DB was created thru DA that can be accessed normally via PHP just fine (localhost, dbname, user, etc)

However, trying to access the DB through Tomcat (default port 8080) returns:

"Error= SQLException: Reg - Server configuration denies access to data source Error: query - null "

Could MySQL be blocking access for some reason?

 

[toml]

Do you have a firewall installed and enabled that would block that port?

 

[brundle]

I do have IPFW running, but first tried to disable it for testing. No change...

I did a grant in mysql to allow 127.0.0.1 and that seemed to work. I am still not sure however why one works and not the other since they are the same thing.

And of course if that continues DA automation will be off because I would have to do a grant statement for every MySQL DB that gets created...