---
title: MySQL SSL Integration Guide
slug: manufacturing-connect-edge/mysql-ssl-integration-guide
docTags: 
createdAt: 2024-01-29T18:34:31.468Z
---

Review the following guide for setting up an integration between Manufacturing Connect Edge and a MySQL database using SSL authentication. 

# Before You Begin

You will need the following:

- Access to a MySQL database with SSL authentication. 
- The CA Certificate and any other required authentication parameters to access the database. 

You can use the following supported versions:

- MySQL (4.1+)
- MariaDB 
- Percona Server
- Google CloudSQL
- Sphinx (2.2.3+)

Refer to the following links to learn more:

- [MySQL Docker Image](https://hub.docker.com/_/mysql)
- [MySQL Documentation](https://dev.mysql.com/doc/)
- [Configuring MySQL to Use Encrypted Connections](https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html)

# Step 1: Add Device

Follow the steps to [Connect a Device](docId\:RFVIJdxz7DBAd8mwbismA). The device will be used to store tags that will be eventually used to create outbound topics in the connector. Make sure to select the **Enable Data Store** checkbox. 

# Step 2: Add Tags

After connecting the device in Manufacturing Connect Edge, you can [Add Tags](docId\:iOaNZd2AwqnkuppgeE3Eh) to the device. Create tags that you want to use to create outbound topics for the connector. 

# Step 3: Add the DB - MySQL SSL Connector

Follow the steps to [Add a Connector](docId\:M2niFNAAdyPHcvZWMCOTo) and select the **DB - MySQL SSL **provider. 

Configure the following parameters. 

- **Name**: Enter a name for the connector. 
- **Hostname**: Paste the IP address you copied in Step 3.  
- **Port**: The port needed to access the database. The default value is **3306**. 
- **CA Certificate**: Paste or upload the CA certificate associated with the database. 
- **Certificate**: Paste or upload the SSL certificate. 
- **Private Key**: Enter or paste the SSL private key. 
- **Username**: Enter the username to access the database. 
- **Password **(Optional): Enter the password associated with the username. 
- **Database**: Enter the database name.  
- **Table**: Enter a name to create a new table or enter the name of an existing table.
- **Show Mapping**: Select the check box to display mappings. See [Work with Tables in SQL Connectors (Create Table and Show Mapping)](docId\:FI9mBipRrRIxufdIHwQl9) to learn more. Too add key/value pairs for the custom table, see [Configure Key/Value Pairs](docId\:FI9mBipRrRIxufdIHwQl9). 
- **Create table**: If you want to send data to an existing table in the default format, or you want to create a new table in the default format, select this checkbox and unselect *Show Mapping*. See [Work with Tables in SQL Connectors (Create Table and Show Mapping)](docId\:FI9mBipRrRIxufdIHwQl9) to learn more. 
- **Commit timeout**: Enter the transaction commit timeout in (ms).
- **Max transaction size**: Enter the maximum number of messages before a transaction is committed, regardless of timeout parameter. 
- **Throttling limit**: The maximum number of messages per second to be processed. The default value is zero, which means that there is no limit. 
- **Persistent storage**: When enabled, this will cause messages to undergo a store-and-forward procedure. Messages will be stored within Manufacturing Connect Edge when cloud providers are online.  
- **Queue Mode**: Select the queue mode as **lifo **(last in first out) or **fifo **(first in first out). Selecting **lifo **means that the last data entry is processed first, and selecting **fifo **means the first data entry is processed first. 

# Step 4: Enable the Connector

After adding the connector, click the toggle in the connector tile to enable it. 

::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/weGcj2dsAg9IMiYUCMwJc_mysqlssl.png" size="60" width="415" height="344" position="center" showCaption="false"}

If you see a *Failed *status, you can review the [Connector Logs](docId\:Zz28hZtQBK7oD_Xsj81O8) and relevant error messages. 

# Step 5: Create Topics for Connector

You will now need to import the tags created in Step 2 as topics for the MySQL connector. The topics will be created as outbound topics. 

**To create outbound topics:**

1. Click the connector tile.
   The connector *Dashboard *appears. 
2. Click the **Topics **tab. 
3. Click the **Import from DeviceHub tags** icon. 
   The *DeviceHub Import* dialog box appears.
   ::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/QUo-NUFfBj7F2BbnlBBj3_importdevicehub.png" size="80" width="1218" height="567" caption="Import from DeviceHub icon" position="center" showCaption="true"}
4. Select all the tags to import and click **Import**. 

After adding all required topics, navigate to the Integration overview page and ensure the connector is not disabled and still shows a CONNECTED status. 

# Step 6: Enable Topics

To enable the topics, return to the Topics tab and click the **Enable all topics** icon. 

![](https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/HhZpomdNLTdfzY5bZfUUj_enablealltopicsicon.png "Enable all topics icon")

# Step 7: Make MySQL Queries

You can now verify that you can view data in the MySQL database. 

Update the credentials, database name, and table name to your own specific configurations. 

**To make MySQL queries:**

1. From the MySQL terminal window, enter `mysql -u user -p` and press **ENTER**.
   *Enter password: *appears.
2. Enter your user password, and then press **ENTER**.
   *Welcome to the MySQL monitor *appears.
3. Enter `show databases;` and press **ENTER**.
   The database name appears.
4. Enter `use sample;`** **and press **ENTER**.
   *Reading table information for completion of table and column names *appears in the console.
5. Enter `show tables;`** **and press **ENTER**.
   The table names for *sample *appear.

6. Enter `select * from test_table;`** **and press **ENTER**.
   Data appears from the imported tags for the connector.