mysql-客户端连接mysql报错
ben 2018-04-01
mysql
假设root用户密码为:123456
错误如下:
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded
原因:
由于MySQL8.0之后的加密规则为"caching_sha2_password",而之前版本的加密规则为"mysql_native_password",可以将加密规则改成"mysql_native_password"
# 1.进入mysql容器
docker exec -it mysql /bin/bash
# 2.进入mysql
mysql -uroot -p123456
# 3.修改密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';