查看设置mysql genneral log

admin

show VARIABLES like '%general_log%';

6 I% K  |8 @/ E  Kset GLOBAL general_log = off;// on-打开; off-关闭

/ a1 \3 _" [4 `0 rgeneral_log ON
general_log_file    /var/log/mysql/query.log

: I- L7 u6 D) t# p

mysql> show VARIABLES like '%general_log%';
7 P6 e1 o& o4 |8 C+------------------+--------------------------+
| Variable_name    | Value                    |
+------------------+--------------------------+
. A) C" u4 E* F4 z9 h* Q| general_log      | ON                       |
$ h2 ?' ^& j# N& N* p| general_log_file | /var/log/mysql/mysql.log |
+------------------+--------------------------+
2 rows in set (0.00 sec)