1234567891011121314151617181920 |
- [mysqld]
- user=mysql # MySQL启动用户
- default-storage-engine=INNODB # 创建新表时将使用的默认存储引擎
- character-set-server=utf8mb4 # 设置mysql服务端默认字符集
- pid-file = /var/run/mysqld/mysqld.pid # pid文件所在目录
- socket = /var/run/mysqld/mysqld.sock # 用于本地连接的socket套接字
- datadir = /var/lib/mysql # 数据文件存放的目录
- #log-error = /var/log/mysql/error.log
- #bind-address = 127.0.0.1 # MySQL绑定IP
- symbolic-links=0
- sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION # 定义mysql应该支持的sql语法,数据校验等!
- # 允许最大连接数
- max_connections=1000
- [mysql]
- default-character-set=utf8mb4
- [client]
- default-character-set=utf8mb4 # 设置mysql客户端默认字符集
|