windows系统mysql5.7安装

1、官网下载mysql-5.7.22-winx64.zip文件，解压缩到D盘，D:\mysql5.7

2、D:\mysql5.7目录下，新建配置

my.ini

[mysqld]

port = 3306
basedir = D:\mysql5.7
datadir = D:\mysql5.7\data
max_connections = 200
character-set-server = utf8
default-storage-engine = INNODB 

[mysql]
default-character-set=utf8

3、管理员运行cmd

d:

cd D:\mysql5.7\bin

#进入bin目录，安装mysql：mysqld install

mysqld install

#初始化data目录，并且为root账户生成空密码：

mysqld --initialize-insecure --user=mysql

#启动mysql服务：

net start mysql

#进入数据库：

mysql -uroot -p

#默认密码为空，接下来修改root的密码：

use mysql;
update user set authentication_string=PASSWORD("123")where user="root";
flush privileges;

ok，完成