3 messages in com.mysql.lists.java--skip-networking and JDBC connection
FromSent OnAttachments
Stas Ostapenko24 Feb 2006 13:31 
Mark Matthews24 Feb 2006 13:48 
Stas Ostapenko02 Mar 2006 03:24 
Subject:--skip-networking and JDBC connection
From:Stas Ostapenko (stas@gmail.com)
Date:02/24/2006 01:31:53 PM
List:com.mysql.lists.java

Hello ! Is it possible to connect to mysql through jdbc driver when mysqld started with --skip-networking option ?. For example as here: "C:\Program Files\MySQL\mysql-4.1.13-win32\bin\mysqld-max-nt.exe" --console --port=8888 --skip-networking --enable-named-pipe.

Connecting via url jdbc:mysql://127.0.0.1:8888/local_storage bring exception :

[java] com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

[java] ** BEGIN NESTED EXCEPTION **

[java] java.net.SocketException [java] MESSAGE: java.net.ConnectException: Connection refused: connect

[java] STACKTRACE:

[java] java.net.SocketException: java.net.ConnectException: Connection refused: connect [java] at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) [java] at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284) [java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:2541) [java] at com.mysql.jdbc.Connection.<init>(Connection.java:1474) [java] at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) [java] at java.sql.DriverManager.getConnection(DriverManager.java:525) [java] at java.sql.DriverManager.getConnection(DriverManager.java:171) [java] at MySQLSkipNetworking.main(Unknown Source)

[java] ** END NESTED EXCEPTION **

[java] Last packet sent to the server was 50 ms ago. [java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:2607) [java] at com.mysql.jdbc.Connection.<init>(Connection.java:1474) [java] at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) [java] at java.sql.DriverManager.getConnection(DriverManager.java:525) [java] at java.sql.DriverManager.getConnection(DriverManager.java:171) [java] at MySQLSkipNetworking.main(Unknown Source)

I'm not sure that it's possible to do the trick. But such functionality will be very useful for me. According to docs : "All interaction with mysqld must be made via named pipes or shared memory (on Windows) or Unix socket files (on Unix). This option is highly recommended for systems where only local clients are allowed."