mysql配置文件

版本1:

[root@d-mysql205 MYSQL]# egrep -v "^$|^#" /etc/my.cnf
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
sql_mode='NO_ENGINE_SUBSTITUTION'
lower_case_table_names=1
skip_name_resolve
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
max_connections = 1000
max_allowed_packet=500M
wait_timeout=288000
interactive_timeout = 288000
max_binlog_size=100M
expire_logs_days=10

原文地址:https://www.cnblogs.com/szy2018/p/12574950.html