MySQL 5.7 Windows MSI 安裝配置圖文全程指引

安裝包獲取

下載 mysql-installer-community-5.7.x.x.msi（含所有元件離線包）。

逐步安裝截圖流程

1. License Agreement：I accept → Next
2. Choosing Setup Type：Developer Default（Full 安裝 Server、Workbench、Shell、Router、文檔、範例）
3. Installation：Execute → 等待所有綠勾
4. Product Configuration：
   - High Availability: Standalone
   - Type: Development Machine
   - Port: 3306，Open Firewall port ✓
   - Root Password：設定並確認
   - Windows Service：Name MySQL57，Auto Start ✓
   - Apply → Execute 配置
5. Accounts and Roles：可新增管理帳號（可跳過）
6. Finish

安裝後驗證

# 開始 → MySQL → MySQL 5.7 Command Line Client
Enter password: ******
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
mysql> SELECT VERSION();  -- 5.7.x

關鍵配置檔位置

• C:\ProgramData\MySQL\MySQL Server 5.7\my.ini（隱藏目錄）
• 資料目錄：C:\ProgramData\MySQL\MySQL Server 5.7\Data\

常見調整

# my.ini 追加/修改
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
max_connections = 500
innodb_buffer_pool_size = 1G  # 視記憶體 60-70%
sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"