解决sqlyog远程连接mysql：Client does not support authentication protocol reuested by server;consider upgrading Mysql client

解决方法

1.进入容器

docker exec -it 62349aa31687 /bin/bash

2.进入mysql

mysql -uroot -p

3.授权

mysql> GRANT ALL ON *.* TO 'root'@'%';

4.刷新授权

mysql> flush privileges;

5.更新加密规则

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

6.更新root密码

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

7.刷新权限

mysql> flush privileges;