python - 为什么在建立 mysql 到 python 连接时出错？

Question

当我在 Python 中连接数据库时出现错误:

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

代码:

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="prakash17"
)
print(mydb)

Answer 1

这里已经回答了这个问题: Authentication plugin 'caching_sha2_password' is not supported

解决方案是安装 mysql-connector-python 而不是 mysql-connector:

pip install mysql-connector-python