MySQL Connector/ODBC 5.1 Type: ODBC Driver Usage: Driver={MySQL ODBC 5.1 Driver} Manufacturer: MySQL More info about this driver » Customize string example values » Local database Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;
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.
Specifying character set Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;charset=UTF8;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;
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.
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 CAsSSLCERT 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.仅供参考,我自己没有弄过!
Type: ODBC Driver
Usage: Driver={MySQL ODBC 5.1 Driver}
Manufacturer: MySQL
More info about this driver »
Customize string
example values »
Local database
Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;
Remote database
Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;
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.
Specifying character set
Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;charset=UTF8;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;
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.
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 CAsSSLCERT 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.仅供参考,我自己没有弄过!