远程连接服务器数据库出现SQLyog连接报错

提示错误：Error No.2058 Plugin caching_sha2_password could not be load

错误原因：mysql8.0版本采用的密码加密方式是caching_sha2_password
解决措施：修改加密方式
先进入容器，然后进入mysql
首先在服务器上进入mysql
执行命令(这里设置的密码为123456根据需要自己修改语句，按照顺序)

mysql> grant all privileges on *.* to root@'%' with grant option;
mysql> alter user 'root'@'%' identified by '123456' password expire never;
mysql> alter user 'root'@'%' identified with mysql_native_password by '123456';
mysql> flush privileges;