After the software installation on Orange Pi PC we proceed to the their configuration
Sensors Monitoring – Envinronment Setup 2
Creating Tables on MySql
On MySql 3 tables have been created containing the values of temperature, humidity and pressure of the sensors.
Here is the MySql model
to import into MySql Workbench
Once imported, access the Database-> Forward Engineering menu and import the tables on your MySql system on the Orange Pi PC, by entering the MySql root user and relative password
At the next screen we use the connection created on MySql Workbench to connect to the database
Leave everything by default and enter the root password when prompted.
The tables are now available on the database
In the next article we configure InfluxDb to store data in real time sent by the sensors
Sensors Monitoring – InfluxDB Configuration