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=0log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
··只有这些
# 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=0log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
··只有这些
解决方案 »
- source insight能否查看变量是赋值还是被赋值
- 如何将win10系统删除只安装ubuntu系统?即电脑上只有Ubuntu系统。
- Qt 在linux系统下调用shell命令 出现使用内存越来越大的情况
- 请教一下关于RedHat Enterprise Linux的许可和服务的问题
- linux每天自动定时关机问题
- 从ubuntu adb push一个文件到Android系统的开发板上,push成功,但是开发板重启后,文件消失
- LinuxCentOS 如何下载libmysqlclient
- linux命令后面的 -l是参数吗?
- 求助关于写shell脚本调用expect登陆别的节点,如何获取返回值判断文件存在
- Linux内核网络协议栈求助
- k8s启动kubelet失败,很奇怪
- bash:print:command not found 求帮助
在WordPress配置界面中可能会出现错误WordPress database error: [Invalid default value for 'user_registered']...这种情况是由于我们现在安装的mysql版本过高,解决办法是修改 /etc/my.cnf (mysql的配置文件)在文件中加上[mysqld]
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION
··
引用原文