6.10 Connecting Using Unix Domain Sockets

Connector/J does not natively support connections to MySQL Servers with Unix domain sockets. However, there is provision for using 3rd-party libraries that supply the function via a pluggable socket factory. Such a custom factory should implement the com.mysql.cj.protocol.SocketFactory interface or the legacy com.mysql.jdbc.SocketFactory interface of Connector/J. Follow these requirements when you use such a custom socket factory for Unix sockets :

• The MySQL Server must be configured with the system variable --socket (for native protocol connections using the JDBC API) or --mysqlx-socket (for X Protocol connections using the X DevAPI), which must contain the file path of the Unix socket file.

• The fully-qualified class name of the custom factory should be passed to Connector/J via the connection property socketFactory. For example, with the junixsocket library, set:

  socketFactory=org.newsclub.net.mysql.AFUNIXDatabaseSocketFactory

  You might also need to pass other parameters to the custom factory as connection properties. For example, for the junixsocket library, provide the file path of the socket file with the property junixsocket.file:

  junixsocket.file=path_to_socket_file