7.3 Using the MySQL Connection String Editor

The MySQL Connection String Editor lists and describes all supported connection-string options for the version of MySQL Connector/NET that you have installed. To open the editor from any web-provider page (see the Connection String entry box), click Edit.

By default, the editor lists connection-string options by category (see the figure that follows). Alternatively, you can sort the list alphabetically using the sorting buttons provided. The main list consists of options on the left and values on the right of a split area. To add a text value, such as the database name, select the option in the list (Database, in this example), and then type the name of the database (sakila) after the cursor. Some connection-string options have predefined values and show a down arrow when selected.

When you select a connection-string option, a brief description is shown in an information box below the list. After you add an option value and then select another option, the editor appends the new option/value pair to the existing connection string. Click OK to return to the web-provider page, which now includes the modified connection string.

Figure 7.5 MySQL Application Configuration Tool - Connection String Editor

Note

Defined connection strings are automatically loaded and available in editor, whether they were created manually in web.config for each application or previously using this tool.