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:
- Open the Configuration dialog of SmartDataSource. See Configuring SmartDataSource
- Select New Connection... button.
- Change the Data Source to be MySQL Database (MySQL Data Provider)
- Fill-in Server name, User name and Password
- If the port number is different then select "Advanced..." button and fill-in the
Port number.
- Select database from the Database name dropdown list.
In addition you can look at the MySQL Connector/NET reference manual