Once the connector is installed, you can use it to create, modify, and delete connections to MySQL databases. To create a connection with a MySQL database, perform the following steps:
Start Visual Studio, and open the Server Explorer window (Control+W, L keyboard shortcuts)., option in the main Visual Studio menu, or
Right-click the Data Connections node, and choose themenu item.
Add Connection dialog opens. Press thebutton to choose MySQL Database as a data source.
Change Data Source dialog opens. Choose MySQL Database in the list of data sources (or the
<other>option, if MySQL Database is absent), and then choose .NET Framework Data Provider for MySQL in the combo box of data providers.
Input the connection settings: the server host name (for example, localhost if the MySQL server is installed on the local machine), the user name, the password, and the default schema name. Note that you must specify the default schema name to open the connection.
You can also set the port to connect with the MySQL server by pressing thebutton. To test connection with the MySQL server, set the server host name, the user name, and the password, and press the button. If the test succeeds, the success confirmation dialog opens.
After you set all settings and test the connection, press. The newly created connection is displayed in Server Explorer. Now you can work with the MySQL server through standard Server Explorer GUI.
After the connection is successfully established, all settings are saved for future use. When you start Visual Studio for the next time, open the connection node in Server Explorer to establish a connection to the MySQL server again.
To modify and delete a connection, use the Server Explorer context menu for the corresponding node. You can modify any of the settings by overwriting the existing values with new ones. Note that the connection may be modified or deleted only if no active editor for its objects is opened: otherwise, you may lose your data.