python2.7集成mysql报错、import mysql.connector 报错、MySQL Connector/Python C Extension not available

本文链接：https://blog.csdn.net/weixin_49114503/article/details/139524266

文章目录

一、报错描述
二、问题解决
- 2.1、怀疑是版本问题，更换较低版本

一、报错描述

本地环境：python2.7、mysql8.0.34

(1)：安装依赖包

pip install mysql-connector-python

在这里插入图片描述

(2): 报错信息如下

D:\App\python\python2.7.13\Python27>python
Python 2.7.13 (v2.7.13:a06454b1afa1, Dec 17 2016, 20:53:40) [MSC v.1500 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import mysql.connector
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "D:\App\python\python2.7.13\Python27\lib\site-packages\mysql\connector\__init__.py", line 32, in <module>
    from .connection_cext import CMySQLConnection
  File "D:\App\python\python2.7.13\Python27\lib\site-packages\mysql\connector\connection_cext.py", line 86
    f"MySQL Connector/Python C Extension not available ({exc})"
                                                              ^
SyntaxError: invalid syntax

二、问题解决

2.1、怀疑是版本问题，更换较低版本

(1)：卸载之前版本，安装更低版本

pip uninstall mysql-connector-python
pip install mysql-connector-python==8.0.21

D:\App\python\python2.7.13\Python27>pip install mysql-connector-python==8.0.21
Collecting mysql-connector-python==8.0.21
  Downloading mysql_connector_python-8.0.21-py2.py3-none-any.whl (366 kB)
     |████████████████████████████████| 366 kB 145 kB/s
Requirement already satisfied: protobuf>=3.0.0 in d:\app\python\python2.7.13\python27\lib\site-packages (from mysql-connector-python==8.0.21) (3.17.3)
Requirement already satisfied: six>=1.9 in d:\app\python\python2.7.13\python27\lib\site-packages (from protobuf>=3.0.0->mysql-connector-python==8.0.21) (1.16.0)
Installing collected packages: mysql-connector-python
Successfully installed mysql-connector-python-8.0.21

mysql-connector-python 版本列表请见 https://dev.mysql.com/doc/relnotes/connector-python/en/

(2)：再次导入成功

D:\App\python\python2.7.13\Python27>pip list
Package                Version
---------------------- ---------
mysql-connector-python 8.0.21
protobuf               3.17.3
six                    1.16.0


D:\App\python\python2.7.13\Python27>python
Python 2.7.13 (v2.7.13:a06454b1afa1, Dec 17 2016, 20:53:40) [MSC v.1500 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import mysql.connector
>>>