MySql连接字符串
来源:互联网 发布:linux时钟同步设置 编辑:程序博客网 时间:2024/06/08 04:57
原贴地址:https://www.connectionstrings.com/mysql/
MySQL Connector/Net
Standard
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Specifying TCP port
Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;
Pwd=myPassword;Multiple servers
Use this to connect to a server in a replicated server configuration without concern on which server to use.
Server=serverAddress1, serverAddress2, serverAddress3;Database=myDataBase;
Uid=myUsername;Pwd=myPassword;Using encryption (old)
This one activates SSL encryption for all data sent between the client and server. The server must have a certificate installed.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Encrypt=true;Using encryption (new)
Use SSL if the server supports it, but allow connection in all cases
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
SslMode=Preferred;Force encryption
Always use SSL. Deny connection if server does not support SSL.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
SslMode=Required;SSL with a file-based certificate
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
SSL Mode=Required;CertificateFile=C:\folder\client.pfx;CertificatePassword=pass;SSL with a personal store-based certificate
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
SSL Mode=Required;Certificate Store Location=CurrentUser;SSL with a thumbprint specific personal store-based certificate
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
SSL Mode=Required;Certificate Store Location=CurrentUser;
Certificate Thumbprint=479436009a40f3017a145cf8479e7694d7aadef0;Disallow batches
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
AllowBatch=False;Allow User Variables
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
AllowUserVariables=True;Invalid DateTime's 1
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
AllowZeroDateTime=True;Invalid DateTime's 2
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ConvertZeroDateTime=True;Disable transaction participation
The use of auto enlist transactionscope (default behaviour) could cause trouble in medium trust environments.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
AutoEnlist=False;Skip parameter checks for stored routines
Default behaviour is that parameters for stored routines (stored procedures) are checked against the server
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
CheckParameters=False;Skip parameter type and order matching for stored procedures
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
UseProcedureBodies=False;Use Table Caching
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
tablecache=true;DefaultTableCacheAge=30;Count changed rows instead of found rows
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
UseAffectedRows=True;Compress network communication between client and server
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
UseCompression=True;Log inefficient database operations
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
UseUsageAdvisor=True;Enable performance counters
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
UsePerformanceMonitor=True;Connection Pooling
From version 6.2 idle connections are removed from the pool, freeing resources on the client (sockets) and the server (sockets and threads). Do not manually keep (global) connections and open close. Keep connection object creation and disposal as tight as possible, this might be counterintuitive but pooling mechanisms will take care of caching well and your code will be cleaner.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Pooling=True;Connection Pool size
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
MinimumPoolSize=10;maximumpoolsize=50;Disable connection pooling
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Pooling=False;Connection state reset when obtained from pool
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ConnectionReset=True;Recycle connections in pool
This is useful in load balancing scenarios when available servers change you don't want 100 constant connections in the pool pointing to only one server.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ConnectionLifeTime=300;Do not update server settings on connections in pool
A connection might be long lived in the pool, however the connections server settings are updated (SHOW VARIABLES command) each time returned to the pool. This makes the client use of the connection object up to date with the correct server settings. However this causes a round trip and to optimize pooling performance this behaviour can be turned off.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
CacheServerProperties=True;Use Windows authentication
Server=myServerAddress;Database=myDataBase;IntegratedSecurity=yes;
Uid=auth_windows;Keep TCP Sockets alive
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Keepalive=10;Use BINARY(16) GUIDs
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
OldGuids=True;Disable Stored procedure cache
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ProcedureCacheSize=0;Allow square brackets around symbols (instead of backticks)
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
sqlservermode=True;Specifying default command timeout
Use this one to specify a default command timeout for the connection. Please note that the property in the connection string does not supercede the individual command timeout property on an individual command object.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
default command timeout=20;Specifying connection attempt timeout
Use this one to specify the length in seconds to wait for a server connection before terminating the attempt and receive an error.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Connection Timeout=5;Inactivating prepared statements
Use this one to instruct the provider to ignore any command prepare statements and prevent corruption issues with server side prepared statements.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Ignore Prepare=true;Specifying network protocol
Use this one to specify which network protocol to use for the connection.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Protocol=socket;Shared memory protocol
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Protocol=memory;Shared Memory Name=MYSQL;Named pipes protocol
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Protocol=pipe;PipeName=mypipename;Named pipes alternative
Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Unix socket connection
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Protocol=memory;Shared Memory Name=MYSQL;Specifying character set
Use this one to specify which character set to use to encode queries sent to the server.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
CharSet=utf8;
MySQLDriverCS
Standard
Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;
Password=myPassword;Port=3306;Extended Properties="""";
SevenObjects MySqlClient
Standard
Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase;
dotConnect for MySQL (former MyDirect.NET and 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;
MySQL OLEDB
Standard
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;
eInfoDesigns.dbProvider
Standard
Data Source=myServerAddress;Database=myDataBase;User ID=myUsername;
Password=myPassword;Command Logging=false;
.NET Framework Data Provider for OLE DB
Use an OLE DB provider from .NET
Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;
MySQL Connector/ODBC 5.2
Unicode version of the driver
Driver={MySQL ODBC 5.2 UNICODE Driver};Server=localhost;Database=myDataBase;
User=myUsername;Password=myPassword;Option=3;Local database
Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost;Database=myDataBase;
User=myUsername;Password=myPassword;Option=3;On 64 bit machine
It seems we need to point on MSDASQL for the (32 bit) ODBC driver to work on 64 bit machines.
Provider=MSDASQL;Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost;
Database=myDataBase;User=myUsername;Password=myPassword;Option=3;Remote database
Driver={MySQL ODBC 5.2 ANSI Driver};Server=myServerAddress;Database=myDataBase;
User=myUsername;Password=myPassword;Option=3;Specifying TCP/IP port
Driver={MySQL ODBC 5.2 ANSI Driver};Server=myServerAddress;Port=3306;
Database=myDataBase;User=myUsername;Password=myPassword;Option=3;Specifying character set
Driver={MySQL ODBC 5.2 ANSI 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.2 ANSI Driver};Server=myServerAddress;Database=myDataBase;
User=myUsername;Password=myPassword;Socket=MySQL;Option=3;Using SSL
Driver={MySQL ODBC 5.2 ANSI 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;
MySQL Connector/ODBC 5.1
Local database
Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase;
User=myUsername;Password=myPassword;Option=3;On 64 bit machine
It seems we need to point on MSDASQL for the (32 bit) ODBC driver to work on 64 bit machines.
Provider=MSDASQL;Driver={MySQL ODBC 5.1 Driver};Server=localhost;
Database=myDataBase;User=myUsername;Password=myPassword;Option=3;64 bit version of the driver
Note the "w" in the driver name.
Driver={MySQL ODBC 5.2w Driver};Server=localhost;Database=myDataBase;
User=myUsername;Password=myPassword;Option=3;Version 5.2.5 new name
MySQL ODBC Connector version 5.2.5 and above register itself as "MySQL ODBC 5.2 Unicode Driver" and "MySQL ODBC 5.2 ANSI Driver".
Driver={MySQL ODBC 5.2 ANSI 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;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;Using SSL
Driver={MySQL ODBC 5.1 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;
MySQL Connector/ODBC 3.51
Local database
Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase;
User=myUsername;Password=myPassword;Option=3;Remote database
Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;Database=myDataBase;
User=myUsername;Password=myPassword;Option=3;Specifying TCP/IP port
Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;Port=3306;
Database=myDataBase;User=myUsername;Password=myPassword;Option=3;Specifying character set
Driver={MySQL ODBC 3.51 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 3.51 Driver};Server=myServerAddress;Database=myDataBase;
User=myUsername;Password=myPassword;Socket=MySQL;Option=3;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;
MyODBC 2.50
Local database
Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase;
Remote database
Driver={mySQL};Server=myServerAddress;Option=131072;Stmt=;Database=myDataBase;
User=myUsername;Password=myPassword;Specifying TCP/IP port
Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=;
Database=myDataBase;User=myUsername;Password=myPassword;
.NET Framework Data Provider for ODBC
Use an ODBC driver from .NET
Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;
- [数据库连接字符串] MySQL 连接字符串
- .net连接mysql字符串
- 连接mysql的字符串
- Mysql连接字符串大全
- MySql 连接字符串详解
- mysql字符串连接函数
- mysql字符串连接函数
- mysql字符串连接函数
- Mysql 字符串连接
- Mysql 的字符串连接
- MySQL连接字符串总结
- MYSQL字符串连接'+'
- mysql 字符串连接
- mysql字符串连接函数
- MySQL连接字符串总结
- mysql 的字符串连接
- mysql中字符串连接
- MySQL连接字符串
- 自适应辛普森法
- CUIT 2016 新生训练题第一周 D-Text Reverse
- H5知识 -- 表单篇
- 在windows10上使用docker哪些坑
- 邮件营销之模板设计 | 五分钟搞定,秒变编辑达人!
- MySql连接字符串
- 好压(HaoZip)的命令行模式用法介绍-转载
- NAT与NAT穿透(二)
- SQL 快速参考
- Linux多线程程序设计
- Android常见问题
- 在C#代码中应用Log4Net(二)典型的使用方式
- Ubuntu14.04安装pycharm用于Python开发环境部署,并且支持pycharm使用中文输入
- MyBatis 核心配置文件 中Url 传递多个值问题 &与&