1、安装

https://blog.csdn.net/li_magic/article/details/70186609

[client]

port=3306

default-character-set=utf8

[mysqld]

port=3306

character_set_server=utf8

basedir=D:\\Develop\\mysql-5.7.21-winx64

datadir=D:\\Develop\\mysql-5.7.21-winx64\\data

[WinMySQLAdmin]

%MYSQL_HOME%\bin\mysqld.exe

2、

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

3、根据菜鸟教程安装，应该装5.7

开始用了8.1，启动服务后怎么也起不来，后来换5.7，需要先移除系统服务

mysqld --remove mysql

4、修改密码

MySQL5.7更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'

update mysql.user set authentication_string=password('root') where user='root' ;

5、计算机中丢失 msvcr110.dll怎么办

https://jingyan.baidu.com/album/4f7d57129fa86e1a201927de.html?picindex=4