win7环境下安装MySQL5.7

记录下在win7 32位环境安装mysql5.7的过程。

1.在mysql官网下载zip archive格式的文件包，下载路径为：https://dev.mysql.com/downloads/mysql/5.7.html#downloads

2.接下zip包,我加压后存放的目录为E:\download\database\mysql\mysql-5.7.25-win32

3.配置环境变量，“环境变量”-“系统变量”

变量名：MYSQL_HOME

变量路径：F:\mysql-5.7.21-win32

在系统环境path后面添加 ;%MYSQL_HOME%\bin

4.在解压的目录下新建my.ini，内容如下：

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
#设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=E:\download\database\mysql\mysql-5.7.25-win32
# 设置mysql数据库的数据的存放目录
datadir=E:\download\database\mysql\mysql-5.7.25-win32\data
# 允许最大连接数
max_connections=2000
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
#开启查询缓存
explicit_defaults_for_timestamp=true
#skip-grant-tables
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB

5.在mysql安装目录下的bin目录执行 mysqld --initialize --console ，得到结果为：

2019-02-05T05:59:11.474386Z 0 [Warning] InnoDB: New log files created, LSN=45790

2019-02-05T05:59:11.869409Z 0 [Warning] InnoDB: Creating foreign key constraint
system tables.
2019-02-05T05:59:11.943413Z 0 [Warning] No existing UUID has been found, so we a
ssume that this is the first time that this server has been started. Generating
a new UUID: 28ebc0a0-290b-11e9-bbe9-fc4dd43b150b.
2019-02-05T05:59:11.949414Z 0 [Warning] Gtid table is not ready to be used. Tabl
e 'mysql.gtid_executed' cannot be opened.
2019-02-05T05:59:12.885467Z 1 [Note] A temporary password is generated for root@
localhost: ddc8pLFvpJ>H

密码为：ddc8pLFvpJ>H

6.安装mysql服务，命令为mysqld --install MySQL5.7

7.windows+R ,弹出运行框,在运行框中输入cmd,回车后进入系统的dos窗口，启动mysql服务

启动mysql：输入 net start mysql5.7;
停止mysql：输入 net stop mysql5.7;

8.登录mysql，命令为mysql -u root -p ,密码为ddc8pLFvpJ>H；执行以下的语句修改密码为root
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

---

2019年03月09日更新：mysql的安装目录中，文件夹名字不要以s开头，否则在初始化initialize时，解析文件夹名字报错