1、官网下载mysql-5.7.22-winx64.zip文件,解压缩到D盘,D:\mysql5.7
2、D:\mysql5.7目录下,新建配置
my.ini
[mysqld]
port = 3306
basedir = D:\mysql5.7
datadir = D:\mysql5.7\data
max_connections = 200
character-set-server = utf8
default-storage-engine = INNODB
[mysql]
default-character-set=utf8
3、管理员运行cmd
d:
cd D:\mysql5.7\bin
#进入bin目录,安装mysql:mysqld install
mysqld install
#初始化data目录,并且为root账户生成空密码:
mysqld --initialize-insecure --user=mysql
#启动mysql服务:
net start mysql
#进入数据库:
mysql -uroot -p
#默认密码为空,接下来修改root的密码:
use mysql;
update user set authentication_string=PASSWORD("123")where user="root";
flush privileges;
ok,完成