In order to connect to MySQL database with Connector/NET you need to first install the connector. The connector can be downloaded from http://dev.mysql.com/downloads/connector/net/6.0.html.

Steps to create connection for MySQL in Visual Studio:

  1. Open the Configuration dialog of SmartDataSource. See Configuring SmartDataSource
  2. Select New Connection... button.
  3. Change the Data Source to be MySQL Database (MySQL Data Provider)
  4. Fill-in Server name, User name and Password
  5. If the port number is different then select "Advanced..." button and fill-in the Port number.
  6. Select database from the Database name dropdown list.

In addition you can look at the MySQL Connector/NET reference manual