my.ini
· 983 B · INI
Brut
[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
| 1 | [client] |
| 2 | port=3306 |
| 3 | default-character-set=utf8mb4 |
| 4 | |
| 5 | [mysql] |
| 6 | no-beep |
| 7 | |
| 8 | [mysqld] |
| 9 | # ========= 基础路径 ========= |
| 10 | basedir=C:/mysql |
| 11 | datadir=C:/mysql/data |
| 12 | tmpdir=C:/mysql/tmp |
| 13 | |
| 14 | # ========= 网络 ========= |
| 15 | port=3306 |
| 16 | |
| 17 | # ========= 字符集 & 排序 ========= |
| 18 | character-set-server=utf8mb4 |
| 19 | collation-server=utf8mb4_0900_ai_ci |
| 20 | |
| 21 | # ========= 时区 ========= |
| 22 | default-time-zone=+08:00 |
| 23 | |
| 24 | # ========= SQL 行为（核心） ========= |
| 25 | sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
| 26 | |
| 27 | # ========= Windows 必须项 ========= |
| 28 | lower_case_table_names=1 |
| 29 | |
| 30 | # ========= 连接 ========= |
| 31 | max_connections=100 |
| 32 | |
| 33 | # ========= 日志 ========= |
| 34 | log-error=C:/mysql/logs/mysql-error.log |
| 35 | slow-query-log=0 |
| 36 | |
| 37 | # ========= InnoDB（开发友好） ========= |
| 38 | innodb_buffer_pool_size=512M |
| 39 | innodb_flush_log_at_trx_commit=1 |
| 40 | innodb_log_buffer_size=16M |
| 41 | innodb_redo_log_capacity=256M |
| 42 | innodb_file_per_table=1 |
| 43 | |
| 44 | # ========= 安全 ========= |
| 45 | secure-file-priv="" |
| 46 | max_allowed_packet=64M |
| 47 |