Data Base Management

MySQL Direct Access

In order to access to the Meshlium Data Base from an external application you have to use the next parameters: 

    IP Wifi:     10.10.10.1
    IP Ethernet: Depending on your DHCP server (You can specify an 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. options are: zigbeeData, 
                    bluetoothData, gpsData)
    Port:        3306
    User:        root
    Passw:       libelium2007

You can also access directly the Meshlium Data Base using the SSH connection.

Via Wifi: 

    #ssh root@10.10.10.1

Via Ethernet: 

    #ssh root@ip_given_by_dhcp

Via Ethernet (if there is no DHCP server) 

    #ssh root@192.168.1.100 
    user: root
    passw: libelium

Remember that you can change the MySQL password in the "Users" section.

Now execute you can enter the MysQL shell (password: libelium2007) 

    meshlium:# mysql -u root -p
    >libelium2007

    mysql> use MeshliumDB;
    Database changed
    mysql> select * from RFIDdata order by ID desc;

or, extract the results of a query directly to an external file without entering to this shell: 

    meshlium:# echo "select * from zigbeeData order by ID_frame desc;" | mysql -u
               root --password="libelium2007" MeshliumDB > /PATH/FILE

The Data Base files can be found at “/mnt/lib/mysql/MeshliumDB/”.

PHPMyAdmin

Also you can manage all mysql databases in Meshlium using “phpmyadmin”. Go to the phpMyAdmin plugin in the Tools section and work directly there or open it in a new browser window.You can also access with at: 

    URL:      http://10.10.10.1/phpmyadmin (If you are not accessing via Wifi or you 
                                            changed this interface the IP may change)
    user:     root
    password: libelium2007
phpMyAdmin inside of Mehlium Manager System

© Libelium Comunicaciones Distribuidas S.L.

| Terms of use