Q0003python链接Mysql数据库报错问题(mysql.connector.errors.NotSupportedError)

转载:https://www.jianshu.com/p/7b0dd384f512

环境

mysql: 8.0.20 MySQL Community Server - GPL
Python: 3.9.2

错误描述

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

解决方案:

(venv) F:pythonSpace>pip install MySQL-connector-python
Collecting MySQL-connector-python
Downloading mysql_connector_python-8.0.23-py2.py3-none-any.whl (379 kB)
|████████████████████████████████| 379 kB 437 kB/s
Collecting protobuf>=3.0.0
Downloading protobuf-3.15.8-py2.py3-none-any.whl (173 kB)
|████████████████████████████████| 173 kB 819 kB/s
Collecting six>=1.9
Downloading six-1.15.0-py2.py3-none-any.whl (10 kB)
Installing collected packages: six, protobuf, MySQL-connector-python
Successfully installed MySQL-connector-python-8.0.23 protobuf-3.15.8 six-1.15.0

本博客为记录本人遇到问题时所找到的解决方案,且均经过本人亲测可用,如有侵权请联系添加来源或删除文章,谢谢。
原文地址:https://www.cnblogs.com/bufuzhou/p/14671739.html