# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
### 默认字符集为utf8
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
### (设定连接mysql数据库时使用utf8mb4编码,以让mysql数据库为utf8mb4运行)
init_connect='SET NAMES utf8mb4'
max_connections=1000
#开启慢查询日志,1s以上的为慢查询
log-slow-queries=slow-query.log
long_query_time=1
binlog_format=mixed
expire_logs_day=8
[mysql]
default-character-set = utf8mb4
[mysqld_safe]
log-error=/var/log/mysqld.log