Mysql Logging

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