CentOS系统下mysql的my.cnf里没有那些配置信息

[a9236229028]

mysql版本5.7.23

··
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
··

只有这些

[a9236229028]

起因是安装wordpress，但是安装的时候出错，查询后发现需要修改my.cnf，但是我my.cnf里什么都没有

··
在WordPress配置界面中可能会出现错误WordPress database error: [Invalid default value for 'user_registered']...

这种情况是由于我们现在安装的mysql版本过高，解决办法是修改 /etc/my.cnf （mysql的配置文件）在文件中加上

[mysqld]
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION
··
引用原文