查看设置mysql genneral log

admin

show VARIABLES like '%general_log%';

0 ]# S" E. Y9 N. A# q4 ?set GLOBAL general_log = off;// on-打开; off-关闭
# S1 ]: V3 n  \
: E! n) K( r3 p% q/ Z- ^general_log ON
- ~2 N, h3 a# D0 [  h9 Ngeneral_log_file    /var/log/mysql/query.log

+ ]4 I4 B- u% B

0 T2 M0 R) B% q8 }' n" }  y  G% ]1 a* \mysql> show VARIABLES like '%general_log%';
  J$ O! q% u0 S: D+ S+------------------+--------------------------+
) U( m; Z7 }( A0 P. B7 U| Variable_name    | Value                    |
+------------------+--------------------------+
| general_log      | ON                       |
| general_log_file | /var/log/mysql/mysql.log |
+------------------+--------------------------+
2 rows in set (0.00 sec)