Have you tried adding a valid user name and password for the remote Mysql server to the getConnection() method
Connection connection = DriverManager.getConnection( "jdbc:mysql://[server ip address]:[port]/[database]", "user", "password");
Simon
Tony Dietrich wrote:
Thanks :-)
I've tried that .. or at least, I've tried testing a database connection from inside NetBeans using the same connection parameters as you suggest,
testing a local database using #
jdbc:mysql://localhost/pp1
succeeds (I have a copy of the database on the local machine, IP 192.168.0.2), but
jdbc:mysql://192.168.0.1:3306/pp1
gives me..
"Server configuration denies access to data source"
Any suggestions? I refuse to give up! <g>
(btw, I do have a mysql hosts permission on 192.168.0.1 for IP 192.168.0.2, for all databases)
On Sat, 2003-03-15 at 12:30, simon wrote:
if you are using java (I asume you are as you are using netbeans) you can connect with
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); Connection connection = DriverManager.getConnection( "jdbc:mysql://[server ip address]/[database]");
you need add the package org.gjt.mm.mysql.Driver to your class path