MySQL

To connect your MySQL database to Neo, you only need a few configuration details and credentials. This guide helps you set it up easily—whether you’re using standard login or secure SSL certificates.

Getting Started

To connect to a MySQL database, you’ll need:

  • Basic connection details like host, port, database

  • One of two authentication options:

    • Standard Authentication (username & password)

    • SSL Authentication (certificates)

Connection Details

Here’s what each field means and how to fill it out:

1. Name

Pick a unique name for this MySQL source.

This is how you’ll recognize the source later when managing multiple sources.

Example:

  • mysql-prod

  • user-service-db

  • team-marketing-mysql

This name must be unique across all your sources.

2. Host

Provide the hostname or IP address of your MySQL server.

Example: mysql.internal.company.com or 10.0.0.12

3. Port

The port used to connect to MySQL server.

Default is 3306 — change it only if your server uses a different port.

4. Database

Enter the name of the database you want to connect to.

Example: customer_data, inventory

Authentication Options

Depending on how your server is configured, you can choose between:

Option 1: Standard Authentication

Use this if your database uses a username and password for login.

You’ll need:

User:

The username you use to access MySQL.

Example: readonly_user

Password:

The corresponding password.

This will be securely masked in the UI.

Option 2: SSL Authentication

Use this if your server requires SSL certificate-based authentication for enhanced security.

You’ll need:

User:

Your MySQL login name.

Password:

The user’s password.

SSL Root Certificate (ssl_ca):

Content of the root certificate (ca.pem) that verifies the server’s identity.

SSL Client Certificate (ssl_cert):

Your client certificate (client-cert.pem) used to authenticate you.

SSL Client Key (ssl_key):

Your private key (client-key.pem) that corresponds to your certificate.

These certificates should be in PEM format and securely stored.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.