軟件包準備
mysql-5.7.11-win32.zip（官網下載）mysql-workbench-community-6.3.6-win32.msivcredist_x64.exe (Visual C++ 2013 Redistributable，Workbench 依賴)
MySQL 安裝步驟
- 解壓至
C:\mysql-5.7.11-win32
- 環境變量：
MYSQL_HOME=C:\mysql-5.7.11-win32
Path=%MYSQL_HOME%\bin
- 創建
my.ini（放置於安裝根目錄），核心配置：
[mysqld]
explicit_defaults_for_timestamp = TRUE
basedir="C:\mysql-5.7.11-win32\"
datadir="C:\mysql-5.7.11-win32\data\"
port = 3306
server_id = 1
character_set_server = utf8
default_storage_engine = INNODB
max_connections = 1024
innodb_buffer_pool_size = 2G
innodb_flush_log_at_trx_commit = 1
innodb_thread_concurrency = 128
sql_mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
innodb_flush_method = normal
- 管理員 CMD：
cd /d C:\mysql-5.7.11-win32\bin
mysqld --install MySQL --defaults-file=C:\mysql-5.7.11-win32\my.ini
mysqld --initialize
- 查看
data\mysql_error_log.err 獲取臨時密碼：
[Note] A temporary password is generated for root@localhost: 5ZC=7Qe&eneg
net start mysql- 登錄修改密碼：
mysql -uroot -p'5ZC=7Qe&eneg'
SET PASSWORD = PASSWORD('123456'); FLUSH PRIVILEGES;
- 驗證：
mysql -uroot -p123456
Workbench 安裝
- 先安裝
vcredist_x64.exe
- 安裝
mysql-workbench-community-6.3.6-win32.msi
- 新建連接：Hostname
127.0.0.1、Port 3306、Username root、Password 123456
關鍵配置說明
explicit_defaults_for_timestamp=TRUE：5.7+ 規範 TIMESTAMP 默認值行為innodb_flush_method=normal：Windows 下推薦，避免 O_DIRECT 不支持問題sql_mode：移除 ONLY_FULL_GROUP_BY 兼容舊應用
