2003解压安装MySQL_windows 安装MySQL服务 zip解压程序

1：配置 my.ini 文件 如下：

[mysql]

default-character-set=utf8

[mysqld]

port=3306

basedir=D:\\Program Files\\databases\\mysql-5.7.24

datadir=D:\\Program Files\\databases\\mysql-5.7.24\\data

max_connections=200

max_connections=200

character-set-server=utf8

default-storage-engine=INNODB

skip-grant-tables:

2：添加MySQL bin目录到path环境变量

执行mysql install

net start mysql 开启服务

3.update user set host='%' where user='root' 允许远程root登录

4.flush privileges;  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456'  修改root 密码