23 lines
938 B
INI
23 lines
938 B
INI
# 服务端参数配置
|
|
[mysqld]
|
|
user=mysql # MySQL启动用户
|
|
default-storage-engine=INNODB # 创建新表时将使用的默认存储引擎
|
|
character-set-server=utf8mb4 # 设置mysql服务端默认字符集
|
|
collation-server=utf8mb4_0900_ai_ci # 数据库字符集对应一些排序等规则，注意要和character-set-server对应
|
|
default-authentication-plugin=mysql_native_password
|
|
|
|
max_connections=1000 # 允许最大连接数
|
|
max_connect_errors=100 # 最大错误连接数
|
|
|
|
#sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
|
|
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
|
|
|
|
lower_case_table_names=1 # 表名不区分大小写
|
|
|
|
[mysql]
|
|
default-character-set=utf8mb4
|
|
|
|
|
|
[client]
|
|
default-character-set=utf8mb4 # 设置mysql客户端默认字符集
|