-196-
v7.3
Database management
Meshlium
X
treme
16. Database management
16.1. Direct access
In order to access to the Meshlium Database from an external application you have to use the next parameters:
•
IP:
-
WiFi:
10.10.10.1
-
Ethernet:
Depending on your DHCP server (You can specify a static IP in the Interfaces section).
192.168.1.100 (if there is no DHCP server).
•
Database:
MeshliumDB.
•
Table:
Depending on the data to be extracted. Some options are: sensorParser, bluetoothData, gpsData,
wifiScan. You can list the tables of the database.
•
Port:
3306
•
User:
root
•
Password:
libelium2007
You can use any management MySQL application like MySQL Workbench or SQLYog to access the database in
Meshlium and perform any maintenance operation.
16.2. PhpMyAdmin
Meshlium has a built in PhpMyAdmin instance that allow local database management. Go to:
Tools
→
phpMyAdmin
Click on “Open in a new window” to open the phpMyAdmin panel.
You can directly access phpMyAdmin panel in the URL:
http://[Meshlium_IP]/phpmyadmin
Where [Meshlium_IP] has to be replaced for the IP used in Meshlium. It can be WiFi AP, Ethernet or 4G IP.
To login, use the credential shown in the section “Direct access”.
Figure: phpMyAdmin login page