win10安装mysql8.0

• 解压

• 放到安装目录

• 添加环境变量

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

• 新建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
  

• 管理员模式CMD运行所有的命令

  # 切换到bin下执行安装mysql
  mysqld -install
  # 初始化数据文件
  mysqld --initialize-insecure --user=mysql
  

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

• 用mysql -uroot -p 免密登录

• 修改密码

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

• 如果客户端连接出现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';