---
title: "Database"
id: "database"
project: "MES User Manual"
url: "https://docs.sepasoft.com/articles/user-manual/database"
updated: 2026-07-31T14:57:03Z
---

# Database

**Sepasoft MES Module Suite**
 #### Database

| ![Information](/resources/Storage/user-manual/user-manual/Info.png) | A database is not required for the Interface for SAP ERP. |
| --- | --- |

##### MySQL
A variety of databases can be used with the Sepasoft MES modules. The MES modules create and maintain their own schemas to store configuration information and production data. All you have to do is provide the database for them to reside in. Since MySQL is free, reliable and easy to use, it is the most common choice for use with Ignition.

This tutorial uses MySQL, so we'll utilize a MySQL ConnectorJ connection to the mes database schema that you created earlier.

**To configure the MySQL database:**

* Open and log in to your **Ignition Gateway** page (*localhost:8088/main/web/home*).
* Go to: **Configure** tab → **Databases** section → **Connections**.
* Click **Create new Database Connection...**
* Choose the**MySQL ConnectorJ** and click **Next**.
* Complete the following configuration items below:
    * **Name:***mes*
    * **Connect URL:***jdbc:[mysql://localhost:3306/mes](mysql://localhost:3306/mes)*
    * **Username:***root*
    * **Password:***12345* (or whatever password you used to create the schema)
    * **Extra Connection Properties:** Append *serverTimezone=UTC* to the end of the settings. This is a new requirement for MyQL Connector/J 8.0. More info is available in [Section 4.14](https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-known-issues-limitations.html) and [Section 4.3.3.1.7](https://dev.mysql.com/doc/connectors/en/connector-j-upgrading-to-8.0.html#connector-j-other-changes) of the MySQL documentation.
* Click **Create New Database Connection** at the bottom of the page.
* Verify that the connection displays "valid" on the database status page before continuing to the next section. We now have a connected database to store the MES data in.
![](/resources/Storage/user-manual/database/db.png)

![](/resources/Storage/user-manual/database/Append%20serverTimezone%20-%20with%20curly%20brace.png)

![](/resources/Storage/user-manual/database/dbconnectionsuccessfully.png)
 * * *

#### Other Database
 You can use any of the other databases supported by Ignition.
 
**Sepasoft MES Module Suite**