| Binary As Guid |
Determines if a provider should treat BINARY(16) columns as guid. Default value is false. |
| Binary Uuid Order |
Defines if a provider should treat BINARY(16) columns as guid in the MySQL UUID_TO_BIN format or in the .NET Guid format. The parameter is applied only if the Binary As Guid parameter is set to true. Default value is false, which means the .NET Guid format. |
| Character Set |
A character set used by the client. Actually, if this property is enabled, then the SET NAMES <Charset> query is executed to establish a connection. Default value is an empty string. That means there is no action performed with charset on the client and on the server. You can set the Charset property value to auto. In this case, the server asks for the charset and sets the appropriate charset on the client. |
| Compress |
If true, enables transferred data compression. The default value is false. |
| Connection Lifetime |
When a connection is returned to a pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. The default value is 0 (connection always returns to pool). |
| Connect Timeout/Connection Timeout |
The length of time (in seconds) to wait for a connection to a server before terminating an attempt and generating an error. The default value is 15. |
| Data Source/Host/Server |
The name or IP address of the host of a MySQL database to which to connect. |
| Database |
The name of a database. |
| Default Auth Plugin |
The name of an authentication plugin. The parameter is applicable only when connecting through the MySQL client library version 5.5 or later. |
| Default Command Timeout |
The time in seconds to wait while trying to execute a command before terminating an attempt and generating an error. 0 indicates no limit. |
| Default FetchAll |
Default value of the MySqlCommand.FetchAll property of MySqlCommand instances, created via the MySqlConnection.CreateCommand method. If the FetchAll mode is enabled, MySqlDataReader object retrieves all the querried data from the server on execution. |
| Direct |
If true, by default, allows not to use the MySQL client library (libmysql.dll) to access a MySQL server. |
| Disable Charset Sending |
Enables or disables explicit charset resetting for a session taken from a pool. |
| Embedded |
If true, allows to use the Embedded MySQL server. The default value is false. |
| Enlist |
Determines whether a connection is automatically enlisted in the current distributed transaction. The default value is true. This parameter is not available in the Mobile Edition. This parameter is also not supported in the .NET Standard 1.3 compatible assembly. |
| FoundRows |
Specifies whether a provider will return the number of rows matched by the WHERE condition of the UPDATE statement instead of the rows changed as the number of changed rows. |
| HTTP Base64 |
Specifies whether to encode data to MIME base64 format before sending it with the POST request when using HTTP tunneling. |
| HTTP Content Length |
Specifies the Content-Length HTTP header parameter. This is the size of a message body in bytes for both client and server. |
| HTTP Host |
Specifies the host name or IP address of a HTTP tunnel server. |
| HTTP Keep Alive |
Specifies the timeout in seconds to send Keep-Alive HTTP packets. |
| HTTP Max Connection Age |
Specifies the maximum connection lifetime in seconds after which a tunnel will be closed. |
| HTTP Password |
Specifies the password for HTTP authorization. |
| HTTP Port |
Defines a port number of a HTTP tunnel server. |
| HTTP Strict Content Length |
Specifies whether data padding should be enabled when message size is smaller than MySqlHttpOptions.ContentLength. |
| HTTP Url |
Determines URL of the tunneling PHP script. For example, if the script is in the server root, the URL can be the following: http://localhost/tunnel.php. |
| HTTP User |
Specifies the username for HTTP authorization. |
| Ignore Prepare |
Defines whether a provider must ignore all MySqlCommand.Prepare calls. The default value is false. |
| Initialization Command |
Specifies a database-specific command that should be executed immediately after establishing a connection. |
| Keep Alive |
Determines whether to send TCP keep-alive packets and the interval at which they are sent in seconds. The default value is 0, which means that the packets are not sent. |
| License Key |
Specify your license key in this parameter. This is required only when you use .NET Standard compatible assemblies. |
| Max Pool Size |
The maximum number of connections allowed in a pool. Setting the Max Pool Size value of the ConnectionString can affect performance. The default value is 100. |
| Min Pool Size |
The minimum number of connections allowed in a pool. The default value is 0. |
| Password |
The account password. |
| Persist Security Info |
Indicates if security-sensitive data, such as the password, is not returned as a part of a connection if it is open or has ever been in an open state. |
| Plugin Dir |
A directory where a plugin is located. The parameter is applicable only when connecting through the MySQL client library version 5.5 or later. |
| Pooling |
If true, by default, the MySqlConnection object is drawn from the appropriate pool or is created and added to the appropriate pool. |
| Port |
The port of a MySQL database to which to connect. The default value is 3306. |
| Protocol |
The type of the network protocol, which will be used to access to a MySQL server. The default value is MySqlProtocol.Tcp. |
| Proxy Host |
The host name or IP address of a proxy server. |
| Proxy Password |
The password for the proxy server account. |
| Proxy Port |
The port of a proxy server. The default value is 3128. |
| Proxy User |
The name of the proxy server account. |
| Server Parameters |
Specifies a command-line argument to launch the Embedded MySQL server. The parameter is usually used to provide a path to files used by a server and a path to a folder where data files are place. For instance: Server Parameters="–basedir=d:/servers/embedded/;–datadir=d:/servers/embedded/data/;". |
| SQL Modes |
The value of the MySQL sql_mode system variable to be set for the session. |
| SSH Authentication Type |
The client authentication method. |
| SSH Cipher List |
The list of ciphers that the client agrees to use. |
| SSH Host |
The name or IP address of a SSH server. |
| SSH Host Key |
A location of the public key on the client side to verify the server host key during establishing a connection. |
| SSH Passphrase |
The passphrase for the client key. |
| SSH Password |
The password for a SSH server. |
| SSH Port |
The port of a SSH server to connect. |
| SSH Private Key |
A location of the private key to use. |
| SSH Strict Host Key Check |
Indicates whether the host key is verified during establishing a connection. |
| SSH User |
The user ID for a SSH server. |
| SSL CA Cert |
A location of the authority certificate. |
| SSL Cert |
A location of the client certificate. |
| SSL Cipher List |
The list of ciphers that the client agrees to use. |
| SSL Key |
A location of the private key. |
| SSL TLS Protocol |
The preferred TLS protocol version, reported to a server when establishing a secure connection. |
| Tiny As Boolean |
Specifies whether a provider should treat TINYINT(1) columns as boolean. The default value is false. |
| Transaction Scope Local |
If there are several connections with the same connection string (which includes “Transaction Scope Local=true;”) within a scope of TransactionScope, our provider will use only one connection internally. The default value is false. The parameter is not available in the Mobile Edition. This parameter is also not supported in the .NET Standard 1.3 compatible assembly. |
| Unicode |
Sets client charset to utf8mb4 for MySQL 5.5.3 and higher or to utf8 for the MySQL versions lower than 5.5.3 and converts client data according to this charset. |
| User ID/User |
The MySQL login account. |
| Validate Connection |
Specifies whether to validate connections obtained from a pool. |