Re: JDBC / remote connection to mysql - ph...@cyberkeep.com - com.mysql.lists.java

4 messages in com.mysql.lists.javaRe: JDBC / remote connection to mysql

From	Sent On	Attachments
Moritz Petersen	23 Mar 2000 03:33
Mark Matthews	23 Mar 2000 03:45
ph...@cyberkeep.com	23 Mar 2000 22:41
Moritz Petersen	24 Mar 2000 10:29

Subject:	Re: JDBC / remote connection to mysql
From:	ph...@cyberkeep.com (ph...@cyberkeep.com)
Date:	03/23/2000 10:41:33 PM
List:	com.mysql.lists.java

I think the port 1114 confusion comes from the fact that the O'Reilly book about mSQL and MySQL shows port 1114 in its JDBC examples. I had the same issues when I first started out.

At 06:46 AM 3/23/00 -0500, you wrote:

Why are you trying to connect to port 1114? MySQL runs on port 3306 by default.

-Mark (author of MM.MySQL)

On Thu, 23 Mar 2000, Moritz Petersen wrote:

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.