MySQL Connector/ODBC 5.2 connection strings

Connects to

MySQL

  • Unicode version of the driver

    Driver={MySQL ODBC 5.2 UNICODE Driver};Server=localhost;Database=myDataBase;
    User
    =myUsername;Password=myPassword;Option=3;

    "MySQL ODBC 5.2 UNICODE Driver" is the new name for "MySQL ODBC 5.1w Driver".

    "MySQL ODBC 5.2 ANSI Driver" is the new name for "MySQL ODBC 5.1a Driver".

  • Local database

    Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost;Database=myDataBase;
    User
    =myUsername;Password=myPassword;Option=3;
  • On 64 bit machine

    It seems we need to point on MSDASQL for the (32 bit) ODBC driver to work on 64 bit machines.

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

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

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

  • Specifying character set

    Driver={MySQL ODBC 5.2 ANSI Driver};Server=myServerAddress;charset=UTF8;
    Database
    =myDataBase;User=myUsername;Password=myPassword;Option=3;
  • 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 5.2 ANSI 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.

  • Using SSL

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

Problems connecting?
Get answer in the MySQL Q & A forum
ODBC DriverDriver={MySQL ODBC 5.2 ANSI Driver}Info and driver downloads

Articlesread all »

Providers

Connect

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.