查看设置mysql genneral log

admin

show VARIABLES like '%general_log%';

) p7 B% y  I+ pset GLOBAL general_log = off;// on-打开; off-关闭

  [9 O4 A4 h" a9 ^( l8 R2 Ugeneral_log ON
general_log_file    /var/log/mysql/query.log
9 l1 [1 [6 \' }, V
% v) K7 @: U8 `! U' R
% G5 l# z; k, Q
mysql> show VARIABLES like '%general_log%';
7 d; k2 [) @' Y& A2 K$ ^: G, J) v+------------------+--------------------------+
3 H* D7 I* m# X, S3 k8 T6 u0 ^| Variable_name    | Value                    |
+------------------+--------------------------+
| general_log      | ON                       |
  O3 M6 F( U" _+ v8 E' P5 || general_log_file | /var/log/mysql/mysql.log |
4 I1 J3 Z: Z9 v$ m* z5 ?% p9 G+------------------+--------------------------+
2 rows in set (0.00 sec)