1、在mysql命令行中输入set global general_log = ‘ON’
2、输入命令show variables like ‘general_log’;查看general_log是否开启
3、输入命令show variables like ‘general_log_file’; 查看日志输出路径
此时的/var/lib/mysql/6a777f799527.log就是mysql查询日志的文件路径
05-22
1029
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
11-08
629
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
12-12
595
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)