We'll create a database connection in the Ignition Gateway configuration section. If you are using a different type of database server than MySQL, then you'll need to set it up accordingly. The instructions below are for MySQL.
- Log in to Configuration and select Databases > Connections from the menu.
- Click on the Create new Database Connection... link to add a new connection.
- Choose the MySQL ConnectorJ for this database.
Give the connection a name, specify the connection URL, and the credentials to use.
Connect URL: jdbc:mysql://localhost:3306/mes
Username: select the username i.e. root
Password: select the password you setup for this user in mysql
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 and Section 220.127.116.11.7 of the MySQL documentation.
Click on the Create New Database Connection button to finish creating the connection.