Authentication plugin 'caching_sha2_password' is not supported

（1）遇到python操作数据库报错

mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

 

 

 （2）解决方法：

1. 修改数据账号密码方式

select user,host,plugin from mysql.user;

 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '数据库root账号密码';

 

2. 安装mysql-connector-python插件