Developers community number 1 connection string reference

Connection strings for MySQL

Community Forums
Find solutions and post questions regarding connection string related issues.

MySQL Connector/Net

Type .NET Framework Class Library
 Usage MySql.Data.MySqlClient.MySqlConnection
 Manufacturer MySQL
Set example values »

More about this class library »

Standard

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Default port is 3306.

 
Copy
 

Specifying port

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Download the driver at MySQL Developer Zone

 
Copy
 

Named pipes

Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

It is the port value of -1 that tells the driver to use named pipes network protocol. This is available on Windows only. The value is ignored if Unix socket is used.

 
Copy
 

Multiple servers

Use this to connect to a server in a replicated server configuration without concern on which server to use.

Server=serverAddress1 & serverAddress2 & etc..;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
 
Copy
 

Using encryption

This one activates SSL encryption for all data sent between the client and server. The server needs to have a certificate installed.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Encryption=true;

This option is available from Connector/NET version 5.0.3. In earlier versions, this option has no effect.

 
Copy
 

Using encryption, alternative

Some reported problems with the above one. Try replacing the key "Encryption" with "Encrypt" instead.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Encrypt=true;
 
Copy
 

Specifying default command timeout

Use this one to specify a default command timeout for the connection. Please note that the property in the connection string does not supercede the individual command timeout property on an individual command object.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;default command timeout=20;

This option is available from Connector/NET version 5.1.4.

 
Copy
 

Specifying connection attempt timeout

Use this one to specify the length in seconds to wait for a server connection before terminating the attempt and receive an error.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Connection Timeout=5;
 
Copy
 

Inactivating prepared statements

Use this one to instruct the provider to ignore any command prepare statements and prevent corruption issues with server side prepared statements.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Ignore Prepare=true;

The option was added in Connector/NET version 5.0.3 and Connector/NET version 1.0.9.

 
Copy
 

Specifying port

Use this one to specify what port to use for the connection.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Port=3306;

The port 3306 is the default MySql port.

The value is ignored if Unix socket is used.

 
Copy
 

Specifying network protocol

Use this one to specify which network protocol to use for the connection.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Protocol=socket;

"socket" is the default value used if the key isn't specified. Value "tcp" is an equivalent for "socket".

Use "pipe" to use a named pipes connection, "unix" for a Unix socket connection and "memory" to use MySQL shared memory.

 
Copy
 

Specifying character set

Use this one to specify which character set to use to encode queries sent to the server.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; CharSet=UTF8;

Note that resultsets still are returned in the character set of the data returned.

 
Copy
 

Specifying shared memory name

Use this one to specify the shared memory object name used for the communication.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Shared Memory Name=MYSQL;

This one is applicable only when the connection protocol value is set to "memory".

 
Copy
 

eInfoDesigns.dbProvider

Type .NET Framework Class Library
 Usage eInfoDesigns.dbProvider.MySqlClient.MySqlConnection
 Manufacturer eInfoDesigns
Set example values »

More about this class library »

Standard

Data Source=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Command Logging=false;
 
Copy
 

SevenObjects MySqlClient

Type .NET Framework Class Library
 Usage
Manufacturer SevenObjects
Set example values »

More about this class library »

Standard

Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase;
 
Copy
 

dotConnect for MySQL (former MyDirect.NET and Core Labs MySQLDirect.NET)

Type .NET Framework Class Library
 Usage Devart.Data.MySql.MySqlConnection
 Manufacturer Devart
Set example values »

More about this class library »

Standard

User ID=root;Password=myPassword;Host=localhost;Port=3306;Database=myDataBase; Direct=true;Protocol=TCP;Compress=false;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;

Read more at Devart (former Core Lab)

 
Copy
 

MySQLDriverCS

Type .NET Framework Class Library
 Usage MySQLDriverCS.MySQLConnection
 Manufacturer MySQLDriverCS project team
Set example values »

More about this class library »

Standard

Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties="""";

This is a free simple .NET compliant MySQL driver.

Project space at SourceForge

 
Copy
 

MySQL OLEDB

Type OLE DB Provider
 Usage Provider=MySQLProv
 Manufacturer MySQL
Set example values »

More about this provider »

Standard

Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;
 
Copy
 

.NET Framework Data Provider for OLE DB

Type .NET Framework Wrapper Class Library
 Usage System.Data.OleDb.OleDbConnection
 Manufacturer Microsoft
Set example values »

More about this wrapper class library »

Bridging to MySQL OLEDB

This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.

Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;
 
Copy
 

MyODBC 2.50

Type ODBC Driver
 Usage Driver={mySQL}
 Manufacturer MySQL
Set example values »

More about this driver »

Local database

Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase;
 
Copy
 

Remote database

Driver={mySQL};Server=myServerAddress;Option=131072;Stmt=;Database=myDataBase; User=myUsername;Password=myPassword;
 
Copy
 

Specifying TCP/IP port

Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=; Database=myDataBase; User=myUsername;Password=myPassword;

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

 
Copy
 

MySQL Connector/ODBC 3.51

Type ODBC Driver
 Usage Driver={MySQL ODBC 3.51 Driver}
 Manufacturer MySQL
Set example values »

More about this driver »

Local database

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

Remote database

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

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.

 
Copy
 

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.

 
Copy
 

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.

 
Copy
 

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.

 
Copy
 

MySQL Connector/ODBC 5.1

Type ODBC Driver
 Usage Driver={MySQL ODBC 5.1 Driver}
 Manufacturer MySQL
Set example values »

More about this driver »

Local database

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

Remote database

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

Specifying TCP/IP port

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

 
Copy
 

Specifying character set

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

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.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.

 
Copy
 

Using SSL

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

 
Copy
 

.NET Framework Data Provider for ODBC

Type .NET Framework Wrapper Class Library
 Usage System.Data.Odbc.OdbcConnection
 Manufacturer Microsoft
Set example values »

More about this wrapper class library »

Bridging to MySQL Connector/ODBC 5.1

This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.

Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;
 
Copy
 
Copyright © 2012 ConnectionStrings.com   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.