MySQL Instance & Item setup
In this guide we will go through the process of setting up an instance to communicate with an MySQL Database using the MySQL Connector on your SIA Connect device
If you need help installing a Connector, we have a guide for that here
| Parameter | Description |
|---|---|
| Name | The name of the instance. This can be anything you want |
| Address | The IP-address of the MySQL Server you are going to connect to |
| Username | The username for an account that has access to the database |
| Password | The password corresponding to the username |
| Database | The name of the database you want to read from |
| Port | The port of the MySQL server you are going to connect to Default: 3306 |
Item setup
In your newly created MySQL Instance you can create items to query the database. SIA Connect connects to the database as any other client, and will be able to execute any queries that the selected user is authorized to perform
| Parameter |
Description |
|---|---|
| Query default |
This is the query that the item will perform in either the given time interval, or when it is triggered by a mapping |