CentOS 7连接mysql 8提示2059 - authentication plugin 'caching_sha2_password

Centos7连接docker的mysql容器出现错误

 

查看docker的mysql容器

docker ps

进入docker里面的mysql

docker exec -it 0caaa58fe8bd bash

然后进入mysql

mysql -u root -p

输入命令发现远程登录的plugin是caching_sha2_password

让我们修改它，修改成mysql_native_password

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root'

如果你是本地登录，则输入

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'

显示连接成功