docker中安装mysql8,出现如下问题:
Client does not support authentication protocol……
解决办法:
1.首先进入mysql容器的bash终端
docker exec -it mysql bash
2.登陆mysql
mysql -u root -p
#接着输入你的密码
然后输入
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
SELECT plugin FROM mysql.user WHERE User = 'root';
主要参考了https://blog.csdn.net/qq_19707521/article/details/80226321,原作者没有指明第一步,补充