mysql命令安装

1.下载mysql压缩包，也可去官网下载

链接：https://pan.baidu.com/s/1PTFpiwP5v7MXOjy6EA313A 
提取码：wmgo

2.安装mysql

https://www.runoob.com/mysql/mysql-install.html?tdsourcetag=s_pcqq_aiomsg

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

修改账户密码加密规则并更新用户密码

#修改加密规则 

   ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;   

#更新一下用户的密码

   ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';   
#刷新权限并重置密码

   FLUSH PRIVILEGES;

如图：

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

mysql>use mysql;
mysql>update user set host = '%' where user = 'root';这一句执行完可能会报错，不用管它。
mysql>FLUSH PRIVILEGES;

如图：

参考链接：

https://www.runoob.com/mysql/mysql-install.html?tdsourcetag=s_pcqq_aiomsg

https://www.cnblogs.com/zhurong/p/9898675.html

https://blog.csdn.net/qq_39781497/article/details/81302950