mysql配置文件

my.cnf

[mysqld]

basedir=/usr/local/Cellar/mysql/5.6.24
pid-file=/usr/local/var/mysql/flowerainsdeMacBook-Pro.local.pid
datadir=/usr/local/var/mysql
plugin-dir=/usr/local/Cellar/mysql/5.6.24/lib/plugin
port=3306
socket= /usr/local/var/mysql/mysql.pid
#server_id = <ALEXMYSQL>

#log
log-error=/usr/local/var/log/mysql/error.log

#日常Log日志
general_log_file= /usr/local/var/log/mysql/mysql.log
general_log= 1

#慢查询
slow_query_log=1
long_query_time=2
slow_query_log_file= /usr/local/var/log/mysql/slowquery.log


[mysqld_safe]
err-log = /usr/local/var/log/mysql/error_safe.log
datadir=/usr/local/var/mysql
pid-file=/usr/local/var/mysql/flowerainsdeMacBook-Pro.local.pid