[client]
port=3306
default-character-set=utf8mb4

[mysql]
no-beep

[mysqld]
# ========= 基础路径 =========
basedir=C:/mysql
datadir=C:/mysql/data
tmpdir=C:/mysql/tmp

# ========= 网络 =========
port=3306

# ========= 字符集 & 排序 =========
character-set-server=utf8mb4
collation-server=utf8mb4_0900_ai_ci

# ========= 时区 =========
default-time-zone=+08:00

# ========= SQL 行为（核心） =========
sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

# ========= Windows 必须项 =========
lower_case_table_names=1

# ========= 连接 =========
max_connections=100

# ========= 日志 =========
log-error=C:/mysql/logs/mysql-error.log
slow-query-log=0

# ========= InnoDB（开发友好） =========
innodb_buffer_pool_size=512M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=16M
innodb_redo_log_capacity=256M
innodb_file_per_table=1

# ========= 安全 =========
secure-file-priv=""
max_allowed_packet=64M