You can use the Connect to MySQL dialog box to specify the information for connecting to a MySQL database via the connection plug-in. This topic describes the options in the dialog box.
Designer displays the Connect to MySQL dialog box when you select the OK button in the Add Driver dialog box, or when you do one of the following in the case that you have already added the MySQL driver in Designer using the Add Driver dialog box:
- Select OK in the Create Connection to MySQL dialog box.
- Select MySQL and select OK in the New Data Source dialog box.
- In the Catalog Manager, right-click a data source and select New JDBC Connection from the shortcut menu, then select MySQL in the Select Connection Type dialog box and select OK.
Designer displays these options:
This option shows the MySQL JDBC driver name that this connection uses.
Specify the host name or IP address of the database server.
Specify the port of the database server.
Specify the name of the database or schema that you want Designer to connect with by default.
Specify the user ID used for accessing the database.
Specify the password used for accessing the database.
Select to show the URL used for connecting to the database server.
This option shows the URL which is formulated by the information you provide. You can also type the valid JDBC URL in the text box to establish the connection to the database server. The URL format is regulated by the driver itself.
Select to test whether the specified connection information can connect to the database successfully.
More Options/Less Options
Select to show or hide the options for experienced users to configure the connection to meet the special requirements of the database.
Select to create the connection to the MySQL database and close the dialog box.
Select to quit creating the connection and close the dialog box.
Select to view information about the dialog box.