Discuss / Python / mysql.connector.errors.NotSupportedError：不支持身份验证插件“caching_sha2_password”
Back

mysql.connector.errors.NotSupportedError：不支持身份验证插件“caching_sha2_password”

Topic source

吃货

#1 Created at ... [Delete] [Delete and Lock User]

连接mysql8.0版本身份验证插件需要用mysql_native_password

conn = mysql.connector.connect(user='root', password='pwd', host='127.0.0.1', database='test', auth_plugin='mysql_native_password')

廖雪峰

#2 Created at ... [Delete] [Delete and Lock User]

去修改mysql配置文件：

[mysqld]
default-authentication-plugin=mysql_native_password

重启mysql

  • 1

Reply