mysql8修改caching_sha2_password为mysql_native_password

/etc/my.cnf文件

[mysqld]下面追加

mysql_native_password=ON

然后重启mysql。

执行sql语句，修改身份验证插件

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'your_password';
FLUSH PRIVILEGES;

这样python设置ssl_disabled就不会报错了。