MySQL for Visual Studio enables you 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 by clickingand then from the main menu.
Right-click the Data Connections node and click.
From the Add Connection dialog, click and select the MySQL Database as a data source.
From the Change Data Source dialog, select MySQL Database from the list of data sources (or the
<other>option, if MySQL Database is absent), and leave .NET Framework Data Provider for MySQL as the data provider.
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 clicking. To test connection with the MySQL server, set the server host name, the user name and the password, and then click . If the test succeeds, the success confirmation dialog opens.
After you set all settings and test the connection, click. 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.
Connections that use the X Protocol can be configured to use SSL with PEM files. To use SSL encryption, connections must be created using the MySQL Connections Manager included with MySQL for Visual Studio 2.0.3 (or later) or with MySQL Workbench.
SSL must be enabled in the target MySQL server instance and the X Plugin must be installed to support connections using SSL encryption and the X Protocol.
To create a connection to a MySQL database using SSL encryption and the X Protocol, perform the following steps:
Click the MySQL icon () in Visual Studio Server Explorer to open the MySQL Connections Manager window.
Clickto create a new connection.
In the Parameters tab, add the host name, port, user name and password, and a default schema. Click to verify the connection information.
In the SSL tab, add a path to the SSL CA, SSL CERT, and SSL Key files within the SSL PEM area. Click to verify the connection information.
Click MySQL Connections Manager window.to save the connection and return to theNote
You must close and then reopen MySQL Connections Manager to apply the default schema.