ConnectionEditor

The connection string specifies the configuration values required to connect to the MySQL database.

To access the Connection Editor, click on the … icon.

Note

Note

• The Connection Editor helps build the connection string with a form that includes the most common connection properties by default.
• You can modify the form by changing default property names, or adding and removing properties.
• You can also paste a connection string into the Connection string property field before opening the editor. The form will display the fields and values from the connection string.

To access the Connection editor, click the ”…” or select it from the dropdown in the Connection string property.

The connection editor looks like this:

Once you have set up a connection to your database, you can create and execute your own SQL queries. Go here for details on SQL Editor.

Examples of connections

MySQL

Below is an example of a MySQL connection string:

Server=localhost;Port=3306;Database=MyDatabase;User Id=MyUser;Password=MyPassword;

Links

Connection strings

• MySQL connection strings