2059 Authentication plugin caching_sha2_password

2059, “Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory”

今天用sqlalchemy连接mysql8.0数据库，一直报错，记录下解决方案

系统默认密码模式是caching_sha2_password
如需修改密码：必须使用mysql_native_password

select user,plugin from user;

然后用下面sql重置下密码，就可以连接了

alter user 'bittorrent'@'%' identified with mysql_native_password by 'bittorrent';
commit;

当然了，为了防止下次修改密码，导致加密模式变化，就是在my.cnf添加

#设置mysql 8.0 的加密方式为 mysql_native_password (默认为:caching_sha2_password)
default_authentication_plugin=mysql_native_password