Parameter | Default Value | Comment |
user | ODBC | The user name used to connect to MySQL. |
uid | ODBC | Synonymous with user . Added in 3.51.16. |
server | localhost | The host name of the MySQL server. |
database | | The default database. |
option | 0 | Options that specify how Connector/ODBC should work. See below. |
port | 3306 | The TCP/IP port to use if server is not localhost . |
initstmt | | Initial statement. A statement to execute when connecting to MySQL. In version 3.51 the parameter is called stmt . Note, the driver supports the initial statement being executed only at the time of the initial connection. |
password | | The password for the user account on server . |
pwd | | Synonymous with password . Added in 3.51.16. |
socket | | The Unix socket file or Windows named pipe to connect to if server is localhost . |
sslca | | The path to a file with a list of trust SSL CAs. Added in 3.51.16. |
sslcapath | | The path to a directory that contains trusted SSL CA certificates in PEM format. Added in 3.51.16. |
sslcert | | The name of the SSL certificate file to use for establishing a secure connection. Added in 3.51.16. |
sslcipher | | A list of allowable ciphers to use for SSL encryption. The cipher list has the same format as the openssl ciphers command Added in 3.51.16. |
sslkey | | The name of the SSL key file to use for establishing a secure connection. Added in 3.51.16. |
charset | | The character set to use for the connection. Added in 3.51.17. |
sslverify | | If set to 1, the SSL certificate will be verified when used with the MySQL connection. If not set, then the default behavior is to ignore SSL certificate verification. |
readtimeout | | The timeout in seconds for attempts to read from the server. Each attempt uses this timeout value and there are retries if necessary, so the total effective timeout value is three times the option value. You can set the value so that a lost connection can be detected earlier than the TCP/IP Close_Wait_Timeout value of 10 minutes. This option works only for TCP/IP connections, and only for Windows prior to MySQL 5.1.12. Corresponds to the MYSQL_OPT_READ_TIMEOUT option of the MySQL Client Library. This option was added in Connector/ODBC 3.51.27. |
writetimeout | | The timeout in seconds for attempts to write to the server. Each attempt uses this timeout value and there are net_retry_count retries if necessary, so the total effective timeout value is net_retry_count times the option value. This option works only for TCP/IP connections, and only for Windows prior to MySQL 5.1.12. Corresponds to the MYSQL_OPT_WRITE_TIMEOUT option of the MySQL Client Library. This option was added in Connector/ODBC 3.51.27. |