mysql8远程连接问题

问题

连接 MySQL8 报错：

2059 - authentication plugin 'caching_sha2_password' cannot be loaded...

解决

1. 修改身份认证插件：mysql_native_password 


   mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Siqing@2021';
   Query OK, 0 rows affected (0.01 sec)

2. 刷新权限
   

   mysql> FLUSH PRIVILEGES;
   Query OK, 0 rows affected (0.01 sec)

测试