Set up a connection to MySQL

Name (required): How you want to refer this connection in integrator.io.

Connection type (required): Select MySQL or accept the default value if youʼre editing a MySQL connection. Note that the type will be listed as “rdbms” in your list of connections.

Mode (required): Select one of the following options:

Agent (required, if On-premise selected for 3. Mode; otherwise disabled): Select an agent from the list. To connect to an on-premise application, integrator.io requires that an agent be installed on a networked computer. An agent is a small application that allows you to connect to data behind your firewall. When installing an agent, you will specify a unique access token, which then populates the Agent drop-down list. The installed agents connect to integrator.io and establish a reverse SSH tunnel, allowing secure communication without the need to whitelist integrator.io’s IP addresses in your firewall settings. A single agent can be used by multiple different connections.

Host (required): Enter the hostname. Use the following steps to find the hostname:

1. Log in to your hostʼs Control Panel and click the MySQL Databases menu. (A quicker alternative might be to search for “MySQL Databases.”)

   

2. Locate your MySQL Database information on the newly opened page.

   

3. Copy the MySQL Host value, and enter it for the MySQL connection’s Host.

Database name (required): Enter the database name as configured by the administrator. (See the MYSQL Database value in the Control Panel example, above.)

Username (required): Enter the database username that was set up when creating the account.

Password (required): Enter the password for the database account.

Port (required): Specify the TCP/IP port on which the MySQL server is listening. (The default port is 3306.)

Use SSL (optional): Check this box to establish a secure connection to the database and encrypt data in transit.

Certificate authority (optional; enabled when 10. Use SSL is checked): If the database uses a certificate that doesn’t match or chain to one of the known CAs, enter a CA certificate that the peer’s certificate can match or chain to. For self-signed certificates, the certificate is its own CA and must be provided. The certificate must be re-entered on subsequent edits to this connection. See MySQL documentation on creating SSL and RSA certificate keys.

Configure properties (optional): Click this button to provide additional name-value pairs to be sent to MySQL with the connection. Click the Save & close button to return to the Connection screen.