1、日志开启
SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';
2、查询
SELECT * from mysql.general_log ORDER BY event_time DESC;
3、日志关闭
SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'OFF';
4、清空表(delete对于这个表,不允许使用,只能用truncate)
truncate table mysql.general_log;