Query Logging aktivieren
- vi /etc/mysql/mysql.conf.d/mysqld.cnf
general_log_file = /var/log/mysql/mysql.log
general_log = 1
Neustarten
- systemctl restart mysql.service
Logging
- tail -f /var/log/mysql/mysql.log
2023-03-11T09:17:24.876094Z 3 Query SET NAMES utf8
2023-03-11T09:17:24.877284Z 3 Query SELECT * FROM my_auth WHERE user='erwin and lisa'
2023-03-11T09:17:24.892720Z 3 Quit
2023-03-11T09:17:40.274993Z 4 Connect xinux@localhost on verwaltung using TCP/IP
2023-03-11T09:17:40.275741Z 4 Query SET NAMES utf8
2023-03-11T09:17:40.276307Z 4 Query SELECT * FROM my_auth WHERE user='erwin'
2023-03-11T09:17:40.278581Z 4 Quit
2023-03-11T09:18:24.382996Z 5 Connect xinux@localhost on verwaltung using TCP/IP
2023-03-11T09:18:24.384263Z 5 Query SET NAMES utf8
2023-03-11T09:18:24.387334Z 5 Quit