1.查看查询日志配置
mysql> show variables like 'general_log%';
+------------------+------------------+
| Variable_name | Value |
+------------------+------------------+
| general_log | ON |
| general_log_file | /tmp/general.log |
+------------------+------------------+
2 rows in set (0.00 sec)
mysql> show variables like 'log_output%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_output | FILE |
+---------------+-------+
1 row in set (0.00 sec)
2.修改
mysql> set global general_log=0;
Query OK, 0 rows affected (0.01 sec)
mysql> show variables like 'general_log%';
+------------------+------------------+
| Variable_name | Value |
+------------------+------------------+
| general_log | OFF |
| general_log_file | /tmp/general.log |
+------------------+------------------+
2 rows in set (0.00 sec)
或者编辑/etc/my.cnf
general_log=on
log_output=file
general_log_file='/tmp/general.log'
3.查看查询日志内容
150817 1:55:05 1 Query desc user
150817 1:55:21 1 Query select user,machine,password from user where user='root'
150817 1:55:39 1 Query select user,host,password from user where user='root'
150817 1:56:00 1 Quit
150817 1:56:06 2 Connect root@localhost on
2 Query select @@version_comment limit 1
150817 1:56:10 2 Quit
150817 1:56:15 3 Connect a@localhost as on
3 Query select @@version_comment limit 1
150817 1:56:16 3 Quit
150817 1:56:20 4 Connect root@localhost on
4 Query select @@version_comment limit 1
150817 1:56:30 4 Query SELECT DATABASE()
4 Init DB mysql
4 Query show databases
4 Query show tables
4 Field List columns_priv
4 Field List db
4 Field List event
4 Field List func
4 Field List general_log
4 Field List help_category
4 Field List help_keyword