Re: JDBC and MySQL

[Cris Perdue]

> I developed a Java application which will work on Windows. This program will access
> MySQL on
> a Unix system in the Internet via TCP/IP. However, I cannot connect to the database.
> I
> contacted the ISP but they cannot help.
>
> I'd greatly appreciate if you can help. Here is the error message I get:
> ===start====================
> java.sql.SQLException: Server configuration denies access to data source
>         at java.lang.Throwable.(Compiled Code)
>         at java.sql.SQLException.(Compiled Code)
>         at org.gjt.mm.mysql.MysqlIO.init(Compiled Code)
>         at org.gjt.mm.mysql.Connection.(Connection.java:230)
>         at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
>         at java.sql.DriverManager.getConnection(Compiled Code)
>         at java.sql.DriverManager.getConnection(DriverManager.java:134)
>         at mysql.main(mysql.java:28)
> ===end====================
>
It certainly appears that the ISP's mysql server is not configured to
permit you to access the database from a remote computer.  Are you sure
they know you are connecting from a remote machine?

As a test, you can try connecting the MySQL command line client from a
remote computer.  You'll probably see the same problem.  If you want to
demonstrate that the problem is in the configuration of MySQL, you might
try accessing the "test" database remotely.  The server *might* let you
do that despite the restrictive configuration.

Also if possible try connecting to a database on a computer system where
you can control the MySQL configuration yourself.
--
Cris Perdue
Impact Online, Inc.
http://www.volunteermatch.org