MySQL msi版安装教程

1.MySQL8.x msi版安装教程

2.可能遇到的错误

     mysql远程连接 Host * is not allowed to connect to this MySQL server

     MySQL 连接出现 Authentication plugin 'caching_sha2_password' cannot be loaded

     ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'

     navicat 连接 mysql 出现Client does not support authentication protocol requested by server解决方案

USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '831015';
FLUSH PRIVILEGES;