windows安装mysql8.x

1）解压

2）放到安装目录

3）添加环境变量

 C:\environment\mysql-8.0.25-winx64\bin

4）在mysql根目录新建mysql配置文件my.ini

[mysqld]
basedir=C:\environment\mysql-8.0.25-winx64\
datadir=C:\environment\mysql-8.0.25-winx64\data\
port=3306
skip-grant-tables

5）安装

# 管理员模式CMD执行命令
# 安装mysql
mysqld -install
# 初始化数据文件
mysqld --initialize-insecure --user=mysql

6）启动

# 注释掉my.ini的skip-grant-tables后启动mysql服务
net start mysql

7）免密登录

mysql -uroot -p

8）修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

9）问题

# 如果客户端连接出现plugin 'caching_sha2_password' cannot be loaded，则如下解决:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

---

2020-10-09 湖南长沙