mysql日志

在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;