1、下载地址
https://dev.mysql.com/downloads/windows/installer/5.7.html
2、安装
3、安装目录
数据目录和my.ini
命令行工具
4、修改密码
set password for 'root'@'localhost'=password('root2');
允许远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root';
刷新权限
flush privileges;
添加用户
CREATE USER 'username'@'host' IDENTIFIED BY 'password’;
//添加后需要设置权限