查看设置mysql genneral log

admin

show VARIABLES like '%general_log%';
$ F. Y! e4 n( `( Z3 v
$ k! A' c! q9 b; [& Qset GLOBAL general_log = off;// on-打开; off-关闭
! F, o" I' o8 y+ z: k/ Y: s
general_log ON
( g4 R! g: v9 D8 z% V- Y8 Bgeneral_log_file    /var/log/mysql/query.log
+ f( x; D1 Q" h% H; V5 f
$ {: S# F' p" ~% o: E2 g' V) I

mysql> show VARIABLES like '%general_log%';
+------------------+--------------------------+
3 ]- a  n' V3 N9 m3 V| Variable_name    | Value                    |
6 b) `& ?) w' W2 x3 v! E2 V; f+------------------+--------------------------+
| general_log      | ON                       |
: ]4 e4 I& S. u) x: @6 m' M7 r| general_log_file | /var/log/mysql/mysql.log |
- v# b* E4 _8 u$ l+ g) P) v+------------------+--------------------------+
9 @# y$ s2 z; M5 L+ Q2 rows in set (0.00 sec)