在my.ini中添加如下数据,重启mysql服务
#sql add 20170815
log-error="E:/mysql/logs/error.log"
log="E:/mysql/logs/all.log"
long_query_time=2
log-slow-queries= "E:/mysql/logs/slow_query.log"
log-bin="E:/mysql/logs/bin.log"
sql查询
show variables like 'log_bin';
show binary logs;
show binlog events;