you must make sure, that not only the user exists in the mymsql grant
tables, but that also the IP-address, which your java application is running
on, is allowed to connect. This may lead to a more complex user-grant table.
I experienced myself some problems, after I added severeal IP-addresses to
the server my servlets are running on. But as I remember my error messages
had said something like "connection refused from IP ??.??.??.??" - so maybe
you can get some more error information which catching the error.
Hope, I could give you some hint, where to search for your problem,
Von: "John Zollinger" <john.zollinger@stripped>
Gesendet: Freitag, 18. Februar 2000 01:58
Betreff: Server configuration denies access to data source?
> I'm having some very odd connection problems.
> Any ideas on what might cause the "Server configuration denies access to
> data source"
> error from JDBC?
> My setup is mysqld running on linux, and my java app using jdbc (mm 2.0b4)
> (which is running on the same machine, JDK1.2.2) tries to connect, but
> with the above error.
> The user I am using for that connection can connect just fine with the
> command, just not through jdbc. BUT, if I start up mysqld with the
> '--skip-grant-tables' flag, my jdbc app can connect just fine.
> It is really odd that I can connect through the mysql util, just not jdbc.
> Perhaps it is network/tcp-ip related?
> Anyone have any clues on what might be going on? I'd rather not have to
> mysql wide-open if I can avoid it.
> John Zollinger
> V.P. Engineering, CTO
> Sundog Technologies, Inc.