MySQL/Java connection problem

hudy · 06-23-2004, 06:43 AM

Hi All!
I have problem with connecting java app to mysql database. I get following error: "Server configuration denies access to Data source".

there are no errors in the program as I can run it under mandrake, but I just cannot run it under redhat. I use under both OS same java version same mysql, same connector.

Any ideas.

I tried also GRANT ALL ON ..... sugested somewhere in miling list rom mysql, but nothing.

linuxxed · 06-23-2004, 07:20 AM

Quote:

Originally posted by hudy
Hi All!
I have problem with connecting java app to mysql database. I get following error: "Server configuration denies access to Data source".

there are no errors in the program as I can run it under mandrake, but I just cannot run it under redhat. I use under both OS same java version same mysql, same connector.

Any ideas.

I tried also GRANT ALL ON ..... sugested somewhere in miling list rom mysql, but nothing.

Where is the client and where is the server. What IP is being passed to mysql server when you are connecting.

Have you tried mysql -u [user] -p[pass] from your RH client to the myserver. Can you connect? If not then you know where the problem is. Check mysql database and the hosts allowed in User and Db table.

hudy · 06-23-2004, 10:07 AM

when i connect i use localhost (no ip address). I can connect from the mysql client to the server from the command line I can view and modify tables. I just cannot connect from the application.

csfalcon · 06-23-2004, 08:40 PM

I didn't run into that error, but this might help

http://www.csfalcon.com/wiki/csfalcon/JDBC