mysql.connector.errors.NotSupportedError: Authentication plugin ‘caching_sha2_password’ is not supported
解决办法
(1)卸载老版本
pip uninstall mysql-connector
(2)安装新的驱动
pip install mysql-connector-python
(3)添加验证方式
import mysql.connector conn = mysql.connector.connect( host="localhost", user="root", passwd="****", auth_plugin='mysql_native_password' ) print(conn)