Specifying socket using MySQL ODBC 5.1

Connection string

This MySQL Connector/ODBC 5.1 connection string can be used for connections to MySQL.

This one specifies the Unix socket file or Windows named pipe to connect to. Used only for local client connections.

Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;
User=myUsername;Password=myPassword;Socket=MySQL;Option=3;

On Windows, the socket variable is the name of the named pipe that is used for local client connections. The default value is MySQL.

On Unix platforms, the socket variable is the name of the socket file that is used for local client connections. The default is /tmp/mysql.sock.