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

本博客为记录本人遇到问题时所找到的解决方案，且均经过本人亲测可用，如有侵权请联系添加来源或删除文章，谢谢。