Connecting to MySQL

Connecting to MySQL

Authenticating a connection to MySQL enables communication between the two platforms. This must be successfully added before Form Connectors can push or Data Source Connectors can pull data.

Adding

The Data Hub area of the platform is where you can add connections for connectors. Navigate the side menu to Data Hub > Connections.

On the Connections page:

  • Click the ADD CONNECTION button in the top-right-hand corner to bring up a list of connections.
  • Click on the MySQL option.

Authenticating

After adding a connection, fill in the required properties and save.

Connection String

Add the MySQL Connection String to be used by connectors to access your database. You must include the Server, Database, User ID, and Password credentials in the string.

The MySQL user specified must have at least CREATE, DELETE, ALTER, INSERT, and SELECT privileges assigned. For the most straightforward configuration, grant all privileges to the user.

Encrypted Connection

MySQL will automatically, by default, encrypt the connection if possible. This option will ensure that the Connector uses SSL encryption for all data sent between the platform and your MySQL server.

Click the SAVE button on the top right to store your configuration and automatically verify the connection. 

Additional Info

  • MySQL connections are only available on Premium accounts, and they must be an Administrator-level user to see the option.
  • The default port for MySQL is 3306. You must ensure this port is open on your firewall and is configured to accept connections from our cloud servers.


Troubleshooting Tips

To help you get your MySQL connection working as quickly as possible, we’ve listed some common connection errors that you might encounter and how you can resolve them.

TLS Version Error

If your MySQL connection fails with the error message:

A connection was successfully established with the server, but then an error occurred during the login process. (provide: SSL Provider; error: 0 – An existing connection was forcibly closed by the remote host)

The error message suggests that your MySQL server does not support TLS 1.2.

All communications between our platform and external servers require support for the TLS 1.2 security protocol as a minimum.

An upgrade/update on your MySQL server to enable TLS 1.2 or higher might be necessary to remedy this issue. If this is the case, you will need to contact your IT team to request this upgrade.

Once your server has been updated, you should see that the Connection will start working.

Check if your database server is configured for TLS 1.2 or higher communication.

    • Related Articles

    • Form Connector – MySQL

      After adding and authenticating a MySQL Connection, you can add Data Source Connectors to pull data from a database or push data on form submissions using Form Connectors, which is what this article is about. Our platform lets you quickly and easily ...

    • Data Source Connector – MySQL

      After adding and authenticating a MySQL Connection, you can add Form Connectors to push data to a database or pull data from a database using Data Source Connectors, which this article is about. Our platform lets you quickly and easily connect Data ...

    • Connecting to OneDrive (Personal)

      MS Graph Connection Recommended We highly recommend connecting your Microsoft services using the Microsoft Graph integration. As the unified gateway to Microsoft 365, a single MS Graph connection securely authenticates SharePoint, OneDrive, and Excel ...

    • Connecting to SharePoint

      Authenticating a connection to SharePoint allows the two platforms to communicate. This authentication must be completed before Form Connectors (SharePoint List and SharePoint Document) can push data or Data Source Connectors can pull data. The ...

    • Connecting to FTP

      Authenticating a connection to an FTP server enables communication between the two platforms. This must be successfully added before Form Connectors can push or Data Sources can pull data. Adding The Data Hub area of the platform is where you can add ...