mysql console


MariaDB [(none)]> SELECT sys_eval ('id ');
+-------------------------------------------------------------+
| sys_eval ('id ')                                            |
+-------------------------------------------------------------+
| uid=109(mysql) gid=116(mysql) groups=116(mysql),1002(mqtt)
 |
+-------------------------------------------------------------+
1 row in set (0.02 sec)

MariaDB [(none)]> SELECT sys_eval ('cat /home/mqtt/test.py ');
+--------------------------------------+
| sys_eval ('cat /home/mqtt/test.py ') |
+--------------------------------------+
| NULL                                 |
+--------------------------------------+
1 row in set (0.02 sec )


console da terminale  con l'account mysql

mysql@scw-a4de6a:/home/matteo01$  cat /etc/group | grep mqtt
mysql:x:116:mqtt
mqtt:x:1002:matteo01,vbocci,mysql
mysql@scw-a4de6a:/home/matteo01$  ls -la /home/mqtt/test.py
-rwxrwxrwx 1 mqtt mqtt 547 Mar 19 01:38 /home/mqtt/test.py
mysql@scw-a4de6a:/home/matteo01$  cat /home/mqtt/test.py
from mysql.connector import (connection)
import datetime
import sys
host1 ="127.0.0.1"
database1 = "mosquitto01"
user1 = "mosquitto"
password1 = "12345678"
porta1="1883"
cnx = connection.MySQLConnection(user=user1,
                              password=password1,
                              host=host1,
                              database=database1)
cursor=cnx.cursor()

cursor.execute(" SELECT id_scena FROM scene")
for row in cursor.fetchall():
        global iddativ
        iddativ=row[0]
        print(iddativ)
sss
mysql@scw-a4de6a:/home/matteo01$