---
title: MySQL
slug: bhdo/mysql
createdAt: 2022-11-24T18:28:37.000Z
---

You can generate data from an edge device, then connect and store the data in the MySQL sample database using the DB-MySQL connector. Data is collected from the selected device.

See the [MySQL 8.0 Reference Manual](https://dev.mysql.com/doc/refman/8.0/en/) for more information.&#x20;

# Step 1: Add Device

Follow the steps to [Connect a Device](https://public-docs.litmus.io/bhdo/connect-a-device). 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** check box.&#x20;

For this use case, select the **Simulator&#x20;**&#x64;evice and **Simulator (Gen1)** driver, and use the name **Product A**.&#x20;

# Step 2: Add Tags

After connecting the device in Belden Horizon Data Operations, you can [Add Tags](https://public-docs.litmus.io/bhdo/add-tags) to the device. Create tags that you want to use to create outbound topics for the connector.&#x20;

For this use case, add two tags with the following details.

- **Name**: Select **int-integer**.&#x20;
- **Value Type**: Select **int**.&#x20;
- **Tag Name**: Enter **temp**.&#x20;
- **Polling Interval**: Enter **1**.&#x20;
- **Address**: Enter **0**.&#x20;



- **Name**: Select **float-float**.&#x20;
- **Value Type**: Select **float**.&#x20;
- **Tag Name**: Enter **pressure**.&#x20;
- **Polling Interval**: Enter **1**.&#x20;
- **Address**: Enter **1**.&#x20;

# Step 3: Add MySQL Marketplace Application

:::hint{type="info"}
**Note**: The version used in this use case for MySQL version is 8.0.
:::

**To add the MySQL Marketplace Application:**

1. In Belden Horizon Data Operations, navigate to **Applications&#x20;**> **Marketplace**.
2. Click **Marketplace List** and select **Default Marketplace Catalog**.
3. Click the **MySQL** application tile.&#x20;
4. From the **Installation script version** drop-down list, select **latest**.&#x20;
5. Configure the following parameters.
   - **Name**: Enter **MySQL**.&#x20;
   - **Database**: Enter **sample**.&#x20;
   - **User**: Enter **user**.&#x20;
   - **Password**: Enter the user password.&#x20;
   - **MySQL password**: Enter the same value as the *Password&#x20;*&#x70;arameter.&#x20;
6. Click **Launch**.&#x20;
7. Navigate to **Applications&#x20;**> **Catalog Apps**.&#x20;
   The MySQL application appears, pulls the image, and then starts the application. The MySQL application shows as running.
8. Navigate to **Applications&#x20;**> **Containers**.&#x20;
   The MySQL application Container is running.
9. Copy the IP address for the MySQL application.

# Step 4: Add the DB - MySQL Connector

Follow the steps to [Add a Connector](https://public-docs.litmus.io/bhdo/add-a-connector) and select the **DB - MySQL&#x20;**&#x70;rovider.&#x20;

Configure the following parameters.&#x20;

- **Name**: A recognizable name to identify the connector.&#x20;
- **Hostname**: Paste the IP address you copied in Step 3. &#x20;
- **Port**: The MySQL Server port. The default value is **3306**.&#x20;
- **Username**: Enter **user**.&#x20;
- **Password&#x20;**(Optional): Enter the user password.&#x20;
- **Database**: Enter **sample**.&#x20;
- **Table**: Enter **test\_table**.&#x20;
- **Show Mapping**: If you want to send data to a custom table, select this check box and unselect *Create table*. See [Work with Tables in SQL Connectors (Create Table and Show Mapping)](https://public-docs.litmus.io/bhdo/work-with-tables-in-sql-connectors-create-table-and-show-mapping) to learn more. To add key/value pairs for the custom table, see [Conigure Key/Value Pairs](https://public-docs.litmus.io/bhdo/work-with-tables-in-sql-connectors-create-table-and-show-mapping#configure-keyvalue-pairs).&#x20;
- **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 check box and unselect *Show Mapping*. See [Work with Tables in SQL Connectors (Create Table and Show Mapping)](https://public-docs.litmus.io/bhdo/work-with-tables-in-sql-connectors-create-table-and-show-mapping) to learn more.&#x20;
- **Throttling limit**: The maximum number of messages per second to be processed. The default value is zero, which means that there is no limit.&#x20;
- **Persistent storage**: When enabled, this will cause messages to undergo a store-and-forward procedure. Messages will be stored within Belden Horizon Data Operations when cloud providers are online. &#x20;

# Step 5: Enable the DB - MySQL Connector

**To enable the connector:&#x20;**

1. Return to th&#x65;*&#x20;Belden Horizon Data Operations Integration* browser tab.
2. Click the connection toggle on the connector tile.&#x20;
   The connector shows connected after verifying the certificate, username, and password.

   ::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/UnGqSjSxhpPNZ5pid8fky_mysql.png" size="60" width="352" height="264" caption="Toggle to enable connector" position="center" showCaption="true"}

# Step 6: Create Topics for MySQL 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.&#x20;

**To create outbound topics:**

1. Click the connector tile.
   The connector *Dashboard&#x20;*&#x61;ppears.&#x20;
2. Click the **Topics&#x20;**&#x74;ab.&#x20;
3. Click the **Import from DeviceHub** tags icon.&#x20;
   The *DeviceHub Import&#x20;*&#x64;ialog box appears.

   ::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/4fC8yaOKctxiiTvUDGfWu_import-from-devicehub.png" size="80" width="1148" height="570" position="center" showCaption="false"}
4. Select all the tags to import and click **Import**.&#x20;

After importing the tags, click the toggle in the connector tile to restart the connection.&#x20;

::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/ZU1LSzWaeABL4SKkv-_HC_mysql.png" size="60" width="352" height="264" caption="Toggle to enable connector" position="center" showCaption="true"}

# Step 7: Enable Topics

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

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

# Step 8: Make Queries in the Container Terminal

**To make queries in the container terminal:**

1. In Belden Horizon Data Operations, navigate to **Applications&#x20;**>**&#x20;Containers**.
2. Click the **Terminal&#xA0;**&#x69;con next to the MySQL container.
   The MySQL shell opens.
3. From the MySQL container terminal, enter **mysql -u user -p** and press **ENTER**.
   `Enter password: `appears.
4. Enter your user password, and then press **ENTER**.
   `Welcome to the MySQL monitor `appears.
5. Enter **show databases;** and press **ENTER**.
   The database name appears.
6. Enter **use sample;&#xA0;**&#x61;nd press **ENTER**.
   `Reading table information for completion of table and column names `appears in the console.
7. Enter **show tables;&#xA0;**&#x61;nd press **ENTER**.
   The table names for **sample&#x20;**&#x61;ppear.

8. Enter **select \* from test\_table;&#xA0;**&#x61;nd press **ENTER**.
   Data appears for the simulator device (Product A) topics.

   ::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/8ySxZhLyQ3WRBEtWPRdq2_applications-mysql-terminal-data.png" size="80" width="1619" height="744" caption="MySQL connection messages" position="center" showCaption="true"}

