1.将官网下载的mysql5.7.36.zip解压到D:\program files下
2.新建my.ini文件(文件格式保存为ANSI格式,否则下面执行mysqld --initialize --console命令时会报错)
[mysqld]
character-set-server=UTF8MB4bind-address=0.0.0.0
port = 3306
basedir=D:\Program Files\mysql-5.7.36-winx64
datadir=D:\Program Files\mysql-5.7.36-winx64\
datamax_connections=2000
default-storage-engine=INNODB
[mysql] default-character-set=utf8 [mysql.server] default-character-set=utf8[client] default-character-set=utf8
3.以管理员身份运行cmd命令,并进入到D:\Program Files\mysql-5.7.36-winx64\bin目录下
4.安装mysql服务:mysqld --install
5.初始化mysql,在这里,初始化会产生一个随机密码,如下图框框所示,记住这个密码,后面会用到(mysqld --initialize --console)
6.开启mysql的服务(net start mysql)
7.登录验证,mysql是否安装成功!
8.修改mysql的密码:set password for root@localhost = password('') 密码为空
9.配置一下环境变量,结束!