mysql my.cnf

发布时间 2023-07-19 08:08:13作者: 秦瑞It行程实录

cat /etc/my.cnf | grep -v "#" | grep -v "^$"
[mysqld]
port=13306
max_allowed_packet=1024M
datadir=/var/lib/mysql/data
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
lower_case_table_names=1
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
group_concat_max_len=18446744073709551615