doracoin a révisé ce gist . Aller à la révision
1 file changed, 46 insertions
my.ini(fichier créé)
| @@ -0,0 +1,46 @@ | |||
| 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 | |
Plus récent
Plus ancien