MySQL connection string operation steps Summary This article mainly describes the actual operation steps of the MySQL connection string, including MySQLConnectorODBC2.50 (mydbc2.50) connection method, MySQLConnectorODBC3.51 (mydbc3.51) the connection method and other related content. 1. MySQLConnecto
Summary of the actual operation steps of the MySQL connection string this article mainly describes the summary of the actual operation steps of the MySQL connection string, including the connection methods of MySQL Connector/ODBC 2.50 (MyODBC 2.50, description of the connection method of MySQL Connector/ODBC 3.51 (MyODBC 3.51. I. MySQL Connecto
Summary of the actual operation steps for MySQL connection strings
This article mainly describes the summary of the actual operation steps for MySQL connection strings, including the connection methods of MySQL ctor/ODBC 2.50 (MyODBC 2.50), MySQL Connector/ODBC 3.51 (MyODBC 3.51) the connection method and other related content.
I. MySQL Connector/ODBC 2.50 (MyODBC 2.50) Connection Mode
1. Local Database Connection
Driver = {MySQL}; Server = localhost; Option = 16834; Database = myDataBase;
2. Remote Data Connection
Driver = {MySQL}; Server = myServerAddress; Option = 131072; Stmt =; Database = myDataBase; User = myUsername; Password = myPassword;
3. Special TCP/IP Port connection
Note: The default port of this Driver is 3306. If it is not specified in the MySQL connection string, port 3306 is connected to MySQL.
Driver = {MySQL}; Server = myServerAddress; Port = 3306; Option = 131072; Stmt =; Database = myDataBase; User = myUsername; Password = myPassword;
Ii. MySQL Connector/ODBC 3.51 (MyODBC 3.51) Connection Mode
1. Local Database Connection
Driver = {MySQL ODBC 3.51 Driver}; Server = localhost; Database = myDataBase; User = myUsername; Password = myPassword; Option = 3;
2. Remote Data Connection
Driver = {MySQL ODBC 3.51 Driver}; Server = data.domain.com; Database = myDataBase; User = myUsername; Password = myPassword; Option = 3;
3. Special TCP/IP Port connection
Note: The default port of this Driver is 3306. If it is not specified in the MySQL connection string, port 3306 is connected to MySQL.
Driver = {MySQL ODBC 3.51 Driver}; Server = data.domain.com; Port = 3306; Database = myDataBase; User = myUsername; Password = myPassword; Option = 3;
4. Special Character Set connection
Driver = {MySQL ODBC 3.51 Driver}; Server = data.domain.com; charset = UTF8; Database = myDataBase; User = myUsername; Password = myPassword; Option = 3;
Iii. ole db, OleDbConnection (. NET) Connection Method
1. Standard connection
Provider = MySQLProv; Data Source = mydb; User Id = myUsername; Password = myPassword;
Iv. MySQL ctor/Net (. NET) Connection Method
1. Standard connection (the default port is 3306 .)
Server = myServerAddress; Database = myDataBase; Uid = myUsername; Pwd = myPassword;
2. Special TCP/IP Port connection
Server = myServerAddress; Port = 1234; Database = myDataBase; Uid = myUsername; Pwd = myPassword;
3. Named Pipe
Note: If the port value is-1, the connection is established using the named pipe. This method is only valid in Windows and is ignored in UNIX.
Server = myServerAddress; Port =-1; Database = myDataBase; Uid = myUsername; Pwd = myPassword;
4. multi-server connection
You do not have to worry about which database to connect.
Server = serverAddress1 & serverAddress2 & etc ..; Database = myDataBase; Uid = myUsername; Pwd = myPassword;
5. Encryption options
This active SSL connection encrypts data transmission between all clients and server vendors. The server must have a certificate.
This option is available from Connector/NET5.0.3, which is unavailable in previous versions.
Server = myServerAddress; Port =-1; Database = myDataBase; Uid = myUsername; Pwd = myPassword;
6. Modify the default command timeout time
Use this command to modify the default connection timeout time. Note: This does not affect the timeout value you set on a single command object.
This entry is only valid for Connector/NET 5.1.4 and later versions.
Server = myServerAddress; Database = myDataBase; Uid = myUsername; Pwd = myPassword; default command timeout = 20;
7. Modify the connection time
Use this modification to terminate the retry and receive the error wait time (in seconds)
Server = myServerAddress; Database = myDataBase; Uid = myUsername; Pwd = myPassword; Connection Timeout = 5;
8. Inactivating prepared statements
Use this one to instruct the provider to ignore any command prepare statements and prevent upload uption issues with server side prepared statements.
This option is added to the 5.0.3 and 1.0.9 versions of Connector/NET.
Server = myServerAddress; Database = myDataBase; Uid = myUsername; Pwd = myPassword; Ignore Prepare = true;
9. Special TCP/IP Port connection
This statement modifies the connected port.
The default port is 3306. This parameter is ignored by Unix.
Server = myServerAddress; Database = myDataBase; Uid = myUsername; Pwd = myPassword; Port = 3306;
10. Special network protocols
This statement modifies the protocol used for connection.
Unless otherwise specified, "socket" is the default value. "Tcp" is of the same significance as "socket. "Pipe" uses named pipe connections, "unix" uses unix socket connections, and "memory" uses MySQL shared memory.
Server = myServerAddress; Database = myDataBase; Uid = myUsername; Pwd = myPassword; Protocol = socket;
11. Special Character Set connection
This statement indicates the query statement that sends the MySQL connection string encoding to the server.
Note: The query results are still transmitted in reverse data format.
Server = myServerAddress; Database = myDataBase; Uid = myUsername; Pwd = myPassword; CharSet = UTF8;
12. Modify the shared memory name
This statement is used to modify the name of the shared memory used for communication.
Note: This statement is valid only when the connection protocol is set to "memory.
Server = myServerAddress; Database = myDataBase; Uid = myUsername; Pwd = myPassword; Shared Memory Name = MySQL;
V. MySQLConnection (. NET) Connection Method
1. eInfoDesigns. dbProvider
Data Source = myServerAddress; Database = myDataBase; User ID = myUsername; Password = myPassword; Command Logging = false;
Vi. SevenObjects MySQLClient (. NET) Connection Method
1. Standard connection
Host = myServerAddress; UserName = myUsername; Password = myPassword; Database = myDataBase;
VII. Core Labs MySQLDirect (. NET) Connection Method
1. Standard connection
User ID = root; Password = myPassword; Host = localhost; Port = 3306; Database = myDataBase; Direct = true; Protocol = TCP; Compress = false; Pooling = true; min Pool Size = 0; Max Pool Size = 100; Connection Lifetime = 0;
VIII. MySQLDriverCS (. NET) Connection Method
1. Standard connection
Location = myServerAddress; Data Source = myDataBase; User ID = myUsername; Password = myPassword; Port = 3306; Extended Properties = """";
Original article title: [MySQL]-MySQL connection string Summary
Connection: http://www.cnblogs.com/hcbin/archive/2010/05/04/1727071.html
[Edit recommendations]