4.1.1.15 Creating a Connection to MySQL Database

To create a connection to a MySQL Database:

1. On the Catalog page, click Create New Item.
2. Hover the mouse over Connection and select Generic Database from the submenu.
3. On the Type Properties screen, enter the following details:
   • Name: Enter a unique name for the connection. This is a mandatory field.
   • Display Name: Enter a display name for the connection. If left blank, the Name field value is copied.
   • Description
   • Tags
   • Connection Type: The selected connection is displayed.
4. Click Next.
5. On the Connection Details screen, enter the following details:
   • database: Select a MySQL database to connect to.
   • Jdbc url: Enter the JDBC connection url to create a database connection.

     The format for a MySQL JDBC url:

     jdbc:mysql://<user>:<password>@<host>:<port>/<database>

     Replace <user>, <password>, <host>, <port>, <database> with the MySQL database username, password, hostname or IP of MySQL database server; the MySQL database server port, and database name respectively.

6. Click Test Connection, to ensure that you have successfully created a connection.
7. Click Save.