MySQL Connection strings - Connectionstring Examples

Connection strings Examples for MySQL

.NET Data Provider for OLE DB

Use this namespace System.Data.OleDb.OleDbConnection for the connection. This is provided from Microsoft.
This is a .NET Framework Wrapper Class Library.

Provider=MySQLProv;Data Source=yourdb;User Id=youUsername;Password=yourPassword;

MySQL OLEDB

This is a OLE DB Provider from MySQL. The usage is Provider=MySQLProv

Standard:

Provider=MySQLProv;Data Source=yourdb;User Id=yourUsername;Password=yourPassword;

MySQL Connector/Net

Dowload at MySQL.com

This is a .NET class library from MySQL. You can use it from MySql.Data.MySqlClient.MySqlConnection.

Standard:

Server=yourServerAddress;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

If no port is specified then the default port is 3306.

Specifying port:

Server=yourServerAddress;Port=1234;Database=yourDataBase;Uid=yourUsername;Pwd=youPassword;

Named Pipes:

Server=yourServerAddress;Port=-1;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

Named pipes tells the driver to use the network protocol and only works on Windows operating system.
On Unix/Linux system this option is ingnored.

Using encryption:

Server=yourServerAddress;Port=1234;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

This option will enable the SSL encryption and only works if the server have SSL certificate installed.
You need to have at least Connector/NET version 5.0.3 for this options.

Multiple servers:

Server=serverAddress1 & serverAddress2 & etc..;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

When there are a replicated server configuration use this option to connect.

Inactivating prepared statements:

Server=yourServerAddress;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;Ignore Prepare=true;

Use this one to instruct the provider to ignore any command prepare statements and prevent corruption issues with
server side prepared statements. Available in Connector/NET version 5.0.3 and Connector/NET version 1.0.9.

Specifying connection attempt timeout:

Server=yourServerAddress;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;Connection Timeout=5;

The time to wait for the server to timeout the connection attempt and recieved an error. Value are measure in second.

Specifying default command timeout:

Server=yourServerAddress;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;default command timeout=20;

Default command time out for the connection.

Specifying network protocol:

Server=yourServerAddress;Port=1234;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

    This option specified which network protocol to use.

    Socket: socket is the default value, even if this option isn't specified.
    tcp: tcp is equivalent to socket.
    pipe: use named pipes connection.
    memory: use MySQL shared memory.

Specifying character set:

Server=yourServerAddress;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword; CharSet=UTF8;

This specify which character set to use when sending query to the server.

Specifying shared memory name:

Server=yourServerAddress;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;Shared Memory Name=MYSQL;

My ODBC 2.5

This is a ODBC driver from MySQL. The usage is Driver={mySQL}

Local database:

Driver={mySQL};Server=localhost;Option=16834;Database=yourDataBase;

Remote database:

Driver={mySQL};Server=yourServerAddress;Option=131072;Stmt=;Database=yourDataBase; User=yourUsername;Password=yourPassword;

Specifying TCP/IP port:

Driver={mySQL};Server=yourServerAddress;Port=3306;Option=131072;Stmt=; Database=yourDataBase; User=yourUsername;Password=yourPassword;

MySQLDriverCS

This is a .NET class library from MySQLDriverCS project team.

Standard:

Location=yourServerAddress;Data Source=yourDataBase;User ID=yourUsername;Password=yourPassword;Port=3306;Extended Properties="""";

dotConnect for MySQL (previously known as MyDirect.NET and Core Labs MySQLDirect.NET)

This is a .NET class library from Devart. You can use it from Devart.Data.MySql.MySqlConnection.

Standard:

Driver={mySQL};Server=localhost;Option=16834;Database=yourDataBase;

MySQL Connector/ODBC 3.51

This is a ODBC driver from MySQL. The usage is Driver={MySQL ODBC 3.51 Driver}

Local database:

Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=yourDataBase; User=yourUsername;Password=yourPassword;Option=3;

Remote database:

Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Database=yourDataBase;User=yourUsername; Password=yourPassword;Option=3;

Specifying TCP/IP port:

Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=yourDataBase;User=yourUsername; Password=yourPassword;Option=3;

Default port for MySQL is 3306 unless otherwise specify during setup.

Specifying Character Set:

Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;charset=UTF8;Database=yourDataBase;User=yourUsername; Password=yourPassword;Option=3;

MySQL Connector/ODBC 5.1

This is a ODBC driver from MySQL. The usage is Driver={MySQL ODBC 5.1 Driver}

Local database:

Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=yourDataBase; User=yourUsername;Password=yourPassword;Option=3;

Remote database:

Driver={MySQL ODBC 5.1 Driver};Server=data.domain.com;Database=yourDataBase;User=yourUsername; Password=yourPassword;Option=3;

Specifying TCP/IP port:

Driver={MySQL ODBC 5.1 Driver};Server=data.domain.com;Port=3306;Database=yourDataBase;User=yourUsername; Password=yourPassword;Option=3;

Default port for MySQL is 3306 unless otherwise specify during setup.

Specifying Character Set:

Driver={MySQL ODBC 5.1 Driver};Server=data.domain.com;charset=UTF8;Database=yourDataBase;User=yourUsername; Password=yourPassword;Option=3;

eInfoDesigns.dbProvider

This is a .NET class library from eInfoDesigns. The usage is eInfoDesigns.dbProvider.MySqlClient.MySqlConnection

Standard:

Data Source=yourServerAddress;Database=yourDataBase;User ID=yourUsername;Password=yourPassword;Command Logging=false;

SevenObjects MySqlClient

This is a .NET class library from SevenObjects.

Standard:

Host=yourServerAddress;UserName=yourUsername;Password=yourPassword;Database=yourDataBase;