登录数据库
mysql -uroot -p
use information_schema;
日志开关
SET GLOBAL log_output = 'TABLE';SET GLOBAL general_log = 'ON'; //日志开启
SET GLOBAL log_output = 'TABLE'; SET GLOBAL general_log = 'OFF'; //日志关闭
查询
SELECT * from mysql.general_log ORDER BY event_time DESC;
清空表
truncate table mysql.general_log;
