Common MySQL Tutorial database tutorial connection string
Myodbc
MYODBC 2.50 Local Database
Driver={mysql}; Server=localhost;option=16834;database=mydatabase;
MYODBC 2.50 Remote Databases
Driver={mysql}; server=myserveraddress; port=3306;option=131072; stmt=; Database=mydatabase; Uid=myusername; Pwd=mypassword;
MYODBC 3.51 Local Database
Driver={mysql ODBC 3.51 Driver}; Server=localhost;database=mydatabase; User=myusername; password=mypassword;option=3;
MYODBC 3.51 Remote databases
Driver={mysql ODBC 3.51 Driver}; server=data.domain.com; Port=3306;database=mydatabase; User=myusername; password=mypassword;option=3;
OLE DB, OleDbConnection (. NET)
Standard
Provider=mysqlprov;data Source=mydb; User Id=myusername; Password=mypassword;
Connector/net 1.0 (. Net)
Standard
Server=myserveraddress;database=mydatabase; Uid=myusername; Pwd=mypassword;
The default port number is 3306.
Specify port number
server=myserveraddress; Port=1234;database=mydatabase; Uid=myusername; Pwd=mypassword;
Named pipes
server=myserveraddress; Port=-1;database=mydatabase; Uid=myusername; Pwd=mypassword;
If the port is-1, it means to tell the driver to use the Named pipe network protocol to connect to the database.
Mysqlconnection (. NET)
Einfodesigns.dbprovider
Data source=myserveraddress;database=mydatabase; User Id=myusername; Password=mypassword; Command Logging=false;
Sevenobjects mysqlclient (. NET)
Standard
host=myserveraddress; Username=myusername; Password=mypassword;database=mydatabase;
Core Labs mysqldirect (. NET)
Standard
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;
Mysqldrivercs (. NET)
Standard
Location=myserveraddress;data source=mydatabase; Userid=myusername; Password=mypassword; port=3306; Extended properties= "" "" ";