1、https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-winx64.zip
去官网下载
2、下载完成后解压
3、配置环境变量
4、
[client] port=3306 default-character-set=utf8 [mysqld] #设置为自己MYSQL的安装目录 basedir=B:\java\mysql\mysql-5.7.19-winx64\ #设置为MYSQL的数据目录 datadir=B:\java\mysql\mysql-5.7.19-winx64\data\ port=3306 character_set_server=utf8 #跳过安全检查 skip-grant-tables
提示:红色的部分为mysql的安装目录 , 需要改成你的mysql安装目录
basedir=B:\java\mysql\mysql-5.7.19-winx64\
datadir=B:\java\mysql\mysql-5.7.19-winx64\data\
5
mysqld --initialize-insecure --user=mysql
6
net start mysql
mysql -u root -p (输入完后直接回车)
use mysql;
update user set authentication_string=password('123456') where user='root' and Host='localhost';
flush privileges;
quit
7
net stop mysql
net start mysql
mysql -u root -p
已经安装完成,如果安装错了用 sc delete mysql清楚服务 再重新安装
接下来下载图形化界面 SQLyog - Download
8、进行测试