Back

Previous Topic Next TopicNext

Connect to MySQL

The Connect to MySQL dialog helps you to specify the information for connecting to a MySQL database via the connection plug-in. It appears when you select OK in the Add Driver dialog, or when you do one of the following in the case that the MySQL driver has been added in Logi Report Designer using the Add Driver dialog:

  • Select OK in the Create Connection to MySQL dialog.
  • Select MySQL and select OK in the New Data Source dialog.
  • 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 and select OK.

Connect to MySQL dialog

Driver

Displays the MySQL JDBC driver name that this connection uses.

Server

Specifies the host name or IP address of the database server.

Port

Specifies the port of the database server.

Database

Specifies the name of the database or schema that you want Logi Report Designer to connect with by default.

User

Specifies the user ID used for accessing the database.

Password

Specifies the password used for accessing the database.

Show URL

Specifies to show the URL used for connecting to the database server.

  • URL
    Displays the URL which is formulated by the information you have provided. 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.

Test Connection

Tests whether the specified connection information can connect to the database successfully.

More Options/Less Options

Shows or hides the options for experienced users to configure the connection to meet the special requirements of the database. Go here for details about the options.

OK

Creates the connection to the MySQL database and closes the dialog.

Cancel

Cancels the connection creation and closes the dialog.

Help

Displays the help document about this feature.

Back to top

BackPrevious Topic Next TopicNext