[mysqld]
default-storage-engine=INNODB
character-set-server=utf8mb4
lower_case_table_names=1
max_connections=1000
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
#secure_file_priv=/var/lib/mysql

#enable binlog
server_id=1
log_bin=/var/lib/mysql/mysql-bin
binlog_format=ROW
binlog_expire_logs_seconds=604800

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4