查看设置mysql genneral log

admin

show VARIABLES like '%general_log%';
0 _- z0 Y2 d. M8 `6 K  ]% `) G- O
9 |2 R2 V! L. t! K6 Cset GLOBAL general_log = off;// on-打开; off-关闭

general_log ON
, ?" I# H& Z* C5 b- ogeneral_log_file    /var/log/mysql/query.log

- ]! I8 E4 K( m

mysql> show VARIABLES like '%general_log%';
3 J; M7 q) [7 S! z/ @9 ?( g6 K+ R+------------------+--------------------------+
| Variable_name    | Value                    |
2 O7 `/ k0 Z( T* X3 t6 y  Y# e+------------------+--------------------------+
3 j7 o# s& Z' [: r/ c& U! ^| general_log      | ON                       |
& d8 {% c4 Y, x# p| general_log_file | /var/log/mysql/mysql.log |
+------------------+--------------------------+
2 rows in set (0.00 sec)