mysql windows下的日志开启

在mysql安装目录下找到my.ini打开在最后面加上下面语句,后面可以设置日志名称

#Enter a name for the error log file.   Otherwise a default name will be used.

log-error=

#Enter a name for the query log file. Otherwise a default name will be used.

log=

#Enter a name for the slow query log file. Otherwise a default name will be used.

log-slow-queries=

#Enter a name for the update log file. Otherwise a default name will be used.

log-update=

#Enter a name for the binary log. Otherwise a default name will be used.

log-bin=