Mysql Connection Strings

This code snippets will explain the connection strings used to connect to MySQL database.

Using the MySql ODBC driver to connect to the local database


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


Using the MySql ODBC driver to connect to the remote database

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

Using the MySQL connector for dotnet

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


Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: