sqlyog连接liunx的docker容器mysql失败

在liunx中

进入docker的mysql

docker exec -it 容器名 bash

进入docker的mysql容器后登陆mysql

mysql -u root -p密码

更改加密规则
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.00 sec)

更新root用户密码
mysql> ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘密码’;
Query OK, 0 rows affected (0.00 sec)

然后刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)