连接Docker启动的mysql出现:ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: ÕÒ²»µ½Ö¸¶¨µÄÄ£¿é¡£
解决方案(在linux环境下):
1.首先docker ps命令查看正在运行的容器,确保我们想要连接的mysql已经启动,如果没启动使用docker start命令启动
2.接着运行docker exec -it b30062adc08c /bin/bash进入mysql容器
docker exec -it mysql2 /bin/bash #mysql2为mysql容器名CONTAINER ID
2.进入mysql
mysql -u root -p
再输入密码
3.修改密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';