mysql-5.7.23 zip版解压安装步骤

1、解压缩mysql-5.7.23-winx64.zip
2、新建.\mysql-5.7.23-winx64\my.ini
[mysqld]
port=3316
character-set-server=utf8
basedir ="C:\mysql-5.7.23-winx64\"
datadir ="C:\mysql-5.7.23-winx64\data\" 
max_allowed_packet = 32M

注意路径要用双引号包裹
3、执行以下命令：
mysqld install MySQL5.7 --defaults-file="C:\mysql-5.7.23-winx64\my.ini" 
mysqld  --initialize
mysqld --defaults-file="C:\mysql-5.7.23-winx64\my.ini" --console --skip-grant-tables
mysql -h127.0.0.1 -P 3316 -u root -p
use mysql;
update mysql.user set authentication_string=password('123456') where user='root'; 
update user set host = '%' where user = 'root';
flush privileges;
quit;
4、mysql密码过期的修改方法（your password has expired）
mysql -h127.0.0.1 -P 3316 -u root -p
set password = password('123456');
flush privileges;
quit;

MySQL8.0安装
mysqld  --initialize --console
mysqld --defaults-file="D:\mysql-8.0.17-winx64\my.ini" --shared-memory --console 
mysql -h127.0.0.1 -P 3306 -u root -p   
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; 
flush privileges;
quit;