首页 / 数据库 / MySQL / MySQL数据库配置文件my.cnf示例

MySQL数据库配置文件my.cnf示例

[mysqld]
bind-address=0.0.0.0
port=3306
character-set-server=utf8mb4
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/data/mysql/mysql.sock
pid-file=/data/mysql/mysql.pid
log-error=/data/mysql/mysql.err
init_connect='set names utf8mb4'
skip-name-resolve
binlog_expire_logs_seconds=86400
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'
[mysql]
default-character-set=utf8mb4
socket=/data/mysql/mysql.sock