sqlyog问题:连接Docker启动的mysql时出现ERROR 2059 (HY000): Authentication plugin ‘caching_sha2_password’ cannot be loaded
说明:mysql版本8.0.19
解决方案:
1.进入mysql容器
docker exec -it mysql01 /bin/bash
2.登录mysql
mysql -uroot -p123456
3.修改密码
ALTER USER ‘root’@’ %’ IDENTIFIED WITH mysql_native_password BY ‘root’;
4.刷新
FLUSH PRIVILEGES;