ExpandedToggleIcon        Connection Dialog

The following connection options are required for connecting to MySQL:

1.Host - The name or network address of MySQL server to which to connect.
2.Port - Number of a port to connect to. The default value is 3306;
3.User Id - The MySQL login account.
4.Password - The password for the MySQL login account.
5.Database - The name of the database to connect to.


In addition to the required options, Advanced connection options may be set for more fine connection tuning or setting up secure connections via SSL or SSH.


ExpandedToggleIcon        Advanced Connection Options

The following table describes the options that you can include in the Connection String using the Advanced Connection Editor dialog box:




Binary As Guid

Determines whether to treat BINARY(16) columns as guid. Default value is false. Note that there are two different binary GUID representations, and another Binary Uuid Order parameter determines which to use.

Binary Uuid Order

Determines whether to treat BINARY(16) values as guid, stored in the format, used by MySQL UUID_TO_BIN function. If set to false, such values are treated as values in the .NET Guid format. This parameter is applied only if the Binary As Guid parameter is set to true.

Char As Guid

Determines whether to treat CHAR(36) columns as guid.

Character Set

A character set used by the client. Actually, if this property is enabled, then the "SET NAMES <Charset>" query is executed on establishing 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.

Client Interactive

Determines the inactivity timeout before the server breaks the connection. If true, the server breaks the connection after number of seconds specified in interactive_timeout sever variable, otherwise wait_timeout is used.


If true, enables transferred data compression. The default value is false.

Connection Lifetime

When a connection is returned to the 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).

Connection Timeout

The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. The default value is 15.


The name of the database.

Default Auth Plugin

The name of the authentication plugin. 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 the attempt and generating an error. 0 indicates no limit.

Default Fetch All

If the FetchAll mode is enabled, all the querried data is retrieved from the server on execution.


If true, by default, allows not to use MySQL client library (libmysql.dll) to access MySQL server.

Disable Charset Sending

Enables or disables explicit charset resetting when a connection is taken from a pool.


If true, allows to use Embedded MySQL server. The default value is false


Determines whether the connection is automatically enlisted in the current distributed transaction. The default value is true.


Specifies whether the provider will return the number of rows matched by the WHERE condition of the UPDATE statement instead of the rows actually changed as the number of changed rows.


The name or IP address of the MySQL server to which to connect.

HTTP Base64

Specifies whether to encode data to MIME base64 format before sending them with the POST Request.

HTTP Content Length

Specifies the value of the Content-Length HTTP header parameter. This is the size of message body in bytes for both client and server.


The host name or IP address of HTTP tunnel server.

HTTP Keep Alive

The timeout in seconds to send Keep-Alive HTTP packets.

HTTP Max Connection Age

The maximum connection age in seconds after which the tunnel will be closed. The default value is 300 seconds.

HTTP Password

The password for HTTP authorization.


The port number of HTTP tunnel server.

HTTP Strict Content Length

Determines whether data padding is enabled when message size is smaller than ContentLength.


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


The user name for HTTP authorization.

Ignore Fractional Seconds

Specifies whether fractional parts of seconds in TIME, DATETIME, and TIMESTAMP values should be ignored.

Ignore Prepare

This parameter is ignored. Do not use this parameter.

Keep Alive

Specifies whether to send TCP keep-alive packets and the interval at which they are sent in seconds. Default value is 0, which means that the packets are not sent.

Max Pool Size

The maximum number of connections allowed in the pool. Setting the Max Pool Size value in the connection string can affect performance. The default value is 100.

Min Pool Size

The minimum number of connections allowed in the pool. The default value is 0.


The password for the account.

Persist Security Info

Indicates if security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state.

Ping Interval

The interval (in seconds) between pinging MySQL server and reopening the connection if required.

Pipe Interval

The name of the pipe to use when connecting via named pipe (Protocol is set to Pipe).

Plugin Dir

The directory where the plugin is located. Applicable only when connecting through the MySQL client library version 5.5 or later.


If true, by default, the connection is drawn from the appropriate pool or is created and added to the appropriate pool.


The port of MySQL database to which to connect. The default value is 3306.


The type of the network protocol which will be used to access to MySQL server. The default value is Tcp. The following values can be used:

Pipe - Named pipe protocol. Works only on Windows systems.
Memory - Shared memory protocol. This type of the network protocol can be used to access MySQL server running on the same computer as Excel. Not supported in Direct mode.
UnixSocket - Unix socket file connection to local server. In the connection string this value may be specified as "unixsocket", "unix socket", or "unix". When using this protocol, you should specify the unix socket file as the Host parameter.
Ssh - SSH protocol.
Ssl - SSL protocol.
Http - HTTP tunneling protocol.
HttpSsl - Secure SSL connection through the HTTP tunneling protocol.


Proxy Host

The host name or IP address of proxy server.

Proxy Password

The password for the proxy server account.

Proxy Port

The port number of the proxy server. The default value is 3128.

Proxy User

The proxy server account name.

Server Parameters

Specifies command-line argument for launching MySQL embedded server. Usually used to provide path to files used by server and path to folder where data files reside. For instance:

Server Parameters=\"--basedir=d:/servers/embedded/;--datadir=d:/servers/embedded/data/;\"

Sql Type

SSH Authentication Type

Client authentication methods. Can include the following values:

PublicKey - Public-key authentication will be used.
Password - Password will be used for authentication.
KeyboardInteractive - Keyboard-interactive authentication will be used.

SSH Cipher List

List of ciphers that client agrees to use. The following ciphers are available for SSH connections:


You can use ALL keyword to indicate whole set of ciphers. To exclude certain cipher from the set use "-" sign. For instance, "ALL-Blowfish" means that any cipher but Blowfish can be used.

SSH Host

The name or ip address of SSH server.

SSH Host Key

The location of the public key on the client side to verify the server host key during establishing connection.

SSH Passphrase

The client key passphrase.

SSH Password

User password on SSH server.

SSH Port

The number of the port on the SSH server to connect.

SSH Private Key

The location of the client private key.

SSH Strict Host Key Checking

Determines whether the host key is verified during establishing connection. The default value is false.

When this option is set to true, the server public key is verified. The verification is successfull if the server key is identical to the key, supplied by user. This key should be specified in the SSH Host Key parameter. If this property is not set or the keys are not equal, the connection is not established. You can get the public host key from system administrator.

SSH User

User id on SSH server.


Location of authority certificate.

SSL Cert

Location of client certificate.

SSL Cipher List

List of ciphers that client agrees to use.


Location of user's private key.

Tiny As Boolean

Specifies whether to treat TINYINY(1) columns as boolean. 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.


If true, sets client charset to utf8mb4 for MySQL 5.5.3 and higher or to utf8 for MySQL versions lower than 5.5.3 and converts client data according to this charset. The default value is false.

User Id

The MySQL login account.

Validate Connection

Specifies whether to validate connections that are being got from the pool.