Can you give me the connection strings for MySQL?

September 11, 2017 0 comments

MySQL Connector/Net

Server=MYSQL_Server_IP;Port=MYSQL_PORT;Database=DATABASE_NAME;Uid=DATABASE_USER;Pwd=DATABASE_USER_PASSWORD;

MySQL Connector/ODBC 3.51

Driver={MySQL ODBC 3.51 Driver};Server=MYSQL_Server_IP;Port=MYSQL_PORT;Database=DATABASE_NAME;User=DATABASE_USER; Password=DATABASE_USER_PASSWORD;Option=3;

MySQL Connector/ODBC 5.1

Driver={MySQL ODBC 5.1 Driver};Server=MYSQL_Server_IP;Port=MYSQL_PORT;Database=DATABASE_NAME;User=DATABASE_USER; Password=DATABASE_USER_PASSWORD;Option=3;

MySQL Connector/ODBC 5.2
For ANSI Records:

Driver={MySQL ODBC 5.2 ANSI Driver};Server=MYSQL_Server_IP;Port=MYSQL_PORT;Database=DATABASE_NAME;User=DATABASE_USER; Password=DATABASE_USER_PASSWORD;Option=3;

For Unicode Records:

Driver={MySQL ODBC 5.2 Unicode Driver};Server=MYSQL_Server_IP;Port=MYSQL_PORT;Database=DATABASE_NAME;User=DATABASE_USER; Password=DATABASE_USER_PASSWORD;Option=3;

MySQL Connector/ODBC 5.3
For ANSI Records:

Driver={MySQL ODBC 5.3 ANSI Driver};Server=MYSQL_Server_IP;Port=MYSQL_PORT;Database=DATABASE_NAME;User=DATABASE_USER; Password=DATABASE_USER_PASSWORD;Option=3;

For Unicode Records:

Driver={MySQL ODBC 5.3 Unicode Driver};Server=MYSQL_Server_IP;Port=MYSQL_PORT;Database=DATABASE_NAME;User=DATABASE_USER; Password=DATABASE_USER_PASSWORD;Option=3;

Sample:

Server=222.222.222.222;Port=3306;Database=MyDatabase;Uid=MyUser;Pwd=MyPassword;

Can you give me the connection strings for MySQL?

How helpful was this article to you?

Leave a comment