Connection strings for MySQL

.NET libraries for MySQL OLE DB providers for MySQL ODBC drivers for MySQL

Developers Community

Find solutions and post questions regarding connection string related issues.

MySQL Connector/Net

More info and class library downloads

Set example values

Standard

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

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

The port 3306 is the default MySql port.

The value is ignored if Unix socket is used.

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

Server=serverAddress1, serverAddress2, serverAddress3;Database=myDataBase;
Uid=myUsername;Pwd=myPassword;

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

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

This option is available for Connector/NET version 5.0.3 through 6.2.1. From 6.2.1 use the SslMode option instead.

Use SSL if the server supports it, but allow connection in all cases

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

This option is available from Connector/NET version 6.2.1

Always use SSL. Deny connection if server does not support SSL.

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

This option is available from Connector/NET version 6.2.1

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
SSL Mode=Required;CertificateFile=C:\folder\client.pfx;CertificatePassword=pass;

This option is available from Connector/NET version 6.2.1

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
SSL Mode=Required;Certificate Store Location=CurrentUser;

This option is available from Connector/NET version 6.2.1

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
SSL Mode=Required;Certificate Store Location=CurrentUser;
Certificate Thumbprint=479436009a40f3017a145cf8479e7694d7aadef0;

This option is available from Connector/NET version 6.2.1

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

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

This option is available from Connector/NET version 5.2.2

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

Returns a MySqlDateTime object for invalid values and a System.DateTime object for valid values.