windows安装mysql（5.7）

1、首先下载
https://dev.mysql.com/downloads/
MySQL Community Server (版本5.7，zip压缩包)

2、解压并剪切到D盘
D:\mysql-5.7.31-winx64

3、环境变量里path追加 D:\mysql-5.7.31-winx64\bin

4、mysql安装目录中新建文件夹data

5、新建文件 my-default.ini
[mysqld]
basedir= D:\mysql-5.7.31-winx64
datadir= D:\mysql-5.7.31-winx64\data

6、管理员运行cmd
d:
cd D:\mysql-5.7.31-winx64\bin
mysqld --initialize-insecure --user=mysql
mysqld install
net start mysql

7、mysql -u root -p
提示输入密码，直接Enter

8、修改root密码(5.7)
use mysql;
update user set authentication_string = password("12345") where user = "root";
flush privileges;
quit;

9、允许别人远程连接
mysql -u root -p
12345
use mysql;
update user set host = '%' where user = 'root';
flush privileges;
quit;

----------------
下载dll
https://forspeed.rbread02.cn/download/pc/msvcr120.zip
http://forspeed.rbread05.cn/down/103917_20161202143142.zip
解压复制到 C:\Windows\System32

应用程序无法正常启动(oxc000007b)
下载vc++语言环境工具
http://forspeed.onlinedown.net/down/DirectXxiufugongju3.7.zip
1 工具 选项 扩展
2 检测