PACEdge User Manual
Section 6
GFK-3178B
Nov 2020
PACEdge Usage Examples
19
6.4
Using MySQL Database
6.4.1
Example Description
This example shows how to use internal and external MQTT brokers and communication.
6.4.2
Prerequisites
If new to Node-RED, completion of the Earthquake Monitor example is highly recommended, as it
shows some Node-RED usage basics and tips.
6.4.3
Example Installation
1.
Open Node-RED.
2.
Click on the menu icon (upper right corner) and choose Import.
3.
Click on Examples.
4.
Expand node-red-contrib-emerson.
5.
Select MySQL and click Import.
6.
An example will appear as a new flow within Node-RED.
Figure 13: New Flow within Node-RED
6.4.4
Example Walk Through
1.
To start with access to the MySQL database needs to be authorized by providing a user
name and password. To do that double click on MySQL Icon
.
2.
Click on the pencil icon next to Database entry.
3.
In the new dialog enter:
a.
User: admin
b.
Password: edgestack
4.
Click Update.
5.
Click Done and then Deploy.
