如何打开MySQL查询日志？

首先找到MySQL的配置文件my.cnf，在[mysqld]下添加

1
general_log_file=~/query.log

同时，登录MySQL console中设置打开log

1
2
3
mysql -uroot

> SET global general_log = 1;

重启MySQL之后就可以在当前用户的HOME目录中通过query.log查看SQL日志了。

例如，当你执行use mysql; select * from user;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
150729 11:51:43	   43 Connect	root@localhost on
		   43 Query	select @@version_comment limit 1
150729 11:51:47	   43 Query	SELECT DATABASE()
		   43 Init DB	mysql
		   43 Query	show databases
		   43 Query	show tables
		   43 Field List	columns_priv
		   43 Field List	db
		   43 Field List	event
		   43 Field List	func
		   43 Field List	general_log
		   43 Field List	help_category
		   43 Field List	help_keyword
		   43 Field List	help_relation
		   43 Field List	help_topic
		   43 Field List	innodb_index_stats
		   43 Field List	innodb_table_stats
		   43 Field List	ndb_binlog_index
		   43 Field List	plugin
		   43 Field List	proc
		   43 Field List	procs_priv
		   43 Field List	proxies_priv
		   43 Field List	servers
		   43 Field List	slave_master_info
		   43 Field List	slave_relay_log_info
		   43 Field List	slave_worker_info
		   43 Field List	slow_log
		   43 Field List	tables_priv
		   43 Field List	time_zone
		   43 Field List	time_zone_leap_second
		   43 Field List	time_zone_name
		   43 Field List	time_zone_transition
		   43 Field List	time_zone_transition_type
		   43 Field List	user
		   43 Query	select * from user

参考：http://stackoverflow.com/questions/6479107/how-to-enable-mysql-query-log