Mysql 5.7.17 windows安裝

下載下傳

my.ini配置

[mysql]
default-character-set=utf8 
[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
basedir = D:\work\DB\mysql-5.7.17-winx64
datadir = D:\work\DB\mysql-5.7.17-winx64\data
port = 3306
# server_id = .....
character-set-server=utf8
default-storage-engine=INNODB


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

安裝-啟動

Mysql 5.7.17 windows安裝

呵呵居然“沒報任何錯誤”。（NET HELPMSG 3534）

查閱資訊居然從5.7.6以後需要執行mysqld --initialize

3.1 執行mysqld -remove指令将以前的錯誤安裝删除，否則會提示已經安裝

Mysql 5.7.17 windows安裝

3.2 執行mysqld --initialize

Mysql 5.7.17 windows安裝

看error日志說data目錄有東西了，清除data中的檔案即可

3.3mysqld -install 然後 net start mysql啟動服務

Mysql 5.7.17 windows安裝

3.4mysql -uroot -p 意料之中的出現下面的提示

Mysql 5.7.17 windows安裝

(Ps：在data目錄下找一下安裝日志ZB-PF0PP2TP.err，一般能找到臨時密碼，别忘了更改它。)

Mysql 5.7.17 windows安裝

找不到的如下方式解決( mysqladmin -u root password 密碼設定初始密碼的方式沒起效！！！)

mysqld --skip-grant-tables #skip-grant-tables的意思是啟動MySQL服務的時候跳過權限表認證。

完事，可能需要你重新打開一個cmd視窗

mysql #進入mysql後
mysql> use mysql   #Database changed
mysql> update mysql.user set authentication_string=password('123456') where user='root' and Host ='localhost';      #在之前的版本中，密碼字段的字段名是 password，5.7版本改為了 authentication_string
mysql> flush privileges;   #更新權限
mysql> quit

找到mysqld的程序kill掉或者登出系統重新開機

在進入mysql會提示讓你重置密碼（不知道為啥還讓修改，推測上一步繞開權限檢測）

Mysql 5.7.17 windows安裝

mysql> set password for [email protected] = password('root'); 
mysql> flush privileges;   #更新權限

原文連結：https://blog.csdn.net/weixin_34329187/article/details/91630436