完美解决ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded问题以及navicat:Authentication plugin 'caching_sha2_password'
1,先查看docker已启动的进程
docker ps
2,使用命令进入docker下的mysql
docker exec -it wg_mysql bash
3,使用命令修改密码
ALTER USER ‘root’@’%’ IDENTIFIED WITH?caching_sha2_password?BY ‘root’;