Connection string is a string that contains information about a data source and means of connection to it.
It is commonly used to connect database to web application.
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=3366;Database=MyDatabase;Uid=MyUser;Pwd=MyPassword;
- 2 Users Found This Useful