Hi,

I have a problem:

Running this code:

public JDBC1() { try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); System.out.println("Driver loaded"); // loading database called "test" String url = "jdbc:mysql://192.168.7.1:1114/test"; // opening connection with user "user" and password "password" Connection con = DriverManager.getConnection(url, "user", "password"); System.out.println("Connection opened"); con.close(); System.out.println("Connection closed"); } catch (Exception e) { System.err.println("Unable to load driver."); e.printStackTrace(); } }

produces the following errors / exceptions:

Driver loaded java.net.ConnectException: OpenTransport error -3260; connection refused at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java) at java.net.Socket.<init>(Socket.java) at java.net.Socket.<init>(Socket.java) at org.gjt.mm.mysql.MysqlIO.<init>(MysqlIO.java:114) at org.gjt.mm.mysql.Connection.<init>(Connection.java:229) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java) at java.sql.DriverManager.getConnection(DriverManager.java) at jdbc1.JDBC1.<init>(JDBC1.java:21) at jdbc1.JDBC1.main(JDBC1.java:36) at com.apple.mrj.JManager.JMStaticMethodDispatcher.run(JMAWTContextImpl.java) at java.lang.Thread.run(Thread.java) Unable to load driver. java.sql.SQLException: Cannot connect to MySQL server on 192.168.7.1:1114. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException) at org.gjt.mm.mysql.Connection.<init>(Connection.java:239) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java) at java.sql.DriverManager.getConnection(DriverManager.java) at jdbc1.JDBC1.<init>(JDBC1.java:21) at jdbc1.JDBC1.main(JDBC1.java:36) at com.apple.mrj.JManager.JMStaticMethodDispatcher.run(JMAWTContextImpl.java) at java.lang.Thread.run(Thread.java)

Maybe mysql is not able to handle remote connections? Then how do I enable remote connections?

Thanks for your help,

Moritz.

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.