首页 > 数据库技术 > 详细

开启mysql sql追踪

时间:2016-05-15 19:38:54      阅读:292      评论:0      收藏:0      [点我收藏+]

my.ini

[mysqld]

# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# The Pipe the MySQL Server will use
# socket=mysql

# The TCP/IP Port the MySQL Server will listen on
port=3306

# Path to installation directory. All paths are usually resolved relative to this.
# basedir="C:/Program Files/MySQL/MySQL Server 5.6/"

# Path to the database root
datadir="C:/ProgramData/MySQL/MySQL Server 5.6/data\"

# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=utf8

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

# Enable Windows Authentication
# plugin-load=authentication_windows.dll

# General and Slow logging.
log-output=FILE
general-log=1
general_log_file="iZ25wc538etZ.log"
slow-query-log=0
slow_query_log_file="iZ25wc538etZ-slow.log"
long_query_time=10

# Binary Logging.
# log-bin

# Error Logging.
log-error="iZ25wc538etZ.err"

重启mysql

查看日志

技术分享

开启mysql sql追踪

原文:http://www.cnblogs.com/hellowzd/p/5495738.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!