navicat12连接mysql,提示plugin caching_sha2_password could not be loaded - …
解决
进入docker容器,然后链接mysql,使用mysql数据库,将root的登陆插件该回去
docker exec -it mysql bash
cd bin
mysql -h localhost -u root -p
use mysql
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';
FLUSH PRIVILEGES;