mysql 5.7 zip安装全过程

1.zip包下载MySQL :: Download MySQL Community Server (Archived Versions)

2.解压安装 MySQL的安装目录创建my.ini文件

[mysqld]
port = 3306
basedir = A:\mysql\mysql-5.7.23-winx64
datadir = A:\mysql\mysql-5.7.23-winx64\data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
default-character-set=utf8

3.管理员模式运行cmd, cd 到MySQL的安装目录的bin目录下执行

mysqld -install

如果报错缺失dll文件

在此下载 https://www.microsoft.com/en-us/download/details.aspx?id=40784

4.再次初始化

mysqld --initialize-insecure --user=mysql

5.添加环境变量

Path后面追加%A:\mysql\mysql-5.7.23-winx64%\bin;

6.启动服务

net start mysql

7.修改密码

SET PASSWORD = PASSWORD("new-password");