常用mysql資料庫連接字串

常用mysql教程資料庫教程連接字串
MyODBC
 
MyODBC 2.50 本機資料庫
 
 

Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase;

 
 
 
MyODBC 2.50 遠端資料庫 
 
 

Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=; Database=myDataBase;Uid=myUsername;Pwd=myPassword;

 
 
 
MyODBC 3.51 本機資料庫
 
 

Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;

 
 
 
MyODBC 3.51 遠端資料庫
 
 

Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

 
 
 
OLE DB, OleDbConnection (.NET)
 
標準
 
 

Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;

 
 
 
Connector/Net 1.0 (.NET)
 
標準
 
 

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

 
 
預設連接埠號碼是3306. 
 
指定連接埠號碼
 
 

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

 
 
 
具名管道
 
 

Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

 
 
如果連接埠是-1，意思是告訴驅動程式使用具名管道網路通訊協定來串連資料庫。
 
MySqlConnection (.NET)
 
eInfoDesigns.dbProvider
 
 

Data Source=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Command Logging=false;

 
 
 
SevenObjects MySqlClient (.NET)
 
標準
 
 

Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase;

 
 
 
Core Labs MySQLDirect (.NET)
 
標準
 
 

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)
 
標準
 
 

Location=myServerAddress;Data Source=myDataBase;UserID=myUsername;Password=myPassword;Port=3306;Extended Properties="""";