• MySQL

    • Local database

      Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase;
      User
      =myUsername;Password=myPassword;Option=3;
      MySQL
    • Remote database

      Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;Database=myDataBase;
      User
      =myUsername;Password=myPassword;Option=3;
      MySQL
    • Specifying TCP/IP port

      Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;Port=3306;
      Database
      =myDataBase;User=myUsername;Password=myPassword;Option=3;

      The driver defaults to port value 3306, if not specified in the connection string, as 3306 is the default port for MySQL.

      MySQL
    • Specifying character set

      Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;charset=UTF8;
      Database
      =myDataBase;User=myUsername;Password=myPassword;Option=3;

      Note that the charset option works from version 3.51.17 of the driver.

      MySQL
    • Specifying socket

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

      Driver={MySQL ODBC 3.51 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.

      MySQL
    • Using SSL

      Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;Database=myDataBase;
      User
      =myUsername;Password=myPassword;sslca=c:\cacert.pem;
      sslcert
      =c:\client-cert.pem;sslkey=c:\client-key.pem;sslverify=1;Option=3;

      SSLCA specifies the path to a file with a list of trust SSL CAs

      SSLCERT specifies the name of the SSL certificate file to use for establishing a secure connection.

      SSLKEY specifies the name of the SSL key file to use for establishing a secure connection.

      MySQL

Articlesread all

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.