查看设置mysql genneral log

admin

show VARIABLES like '%general_log%';
# X0 e& J+ F5 ?) K* D5 |' }4 D! z
+ W* ]* r+ o5 @5 B& J% ]4 ~set GLOBAL general_log = off;// on-打开; off-关闭
8 g7 E6 e! Z, O6 \8 o0 ^
general_log ON
& Y% H7 c3 i% x' P+ ngeneral_log_file    /var/log/mysql/query.log
- f# X; X6 @& P% a" l# H5 m


0 A0 ^$ A+ M- v4 \; ~" C; |/ A0 T4 i4 wmysql> show VARIABLES like '%general_log%';
+------------------+--------------------------+
5 _: y  u& z% o/ v2 V| Variable_name    | Value                    |
+------------------+--------------------------+
| general_log      | ON                       |
| general_log_file | /var/log/mysql/mysql.log |
+------------------+--------------------------+
2 rows in set (0.00 sec)