python使用mysql.connector.connect报错

Traceback (most recent call last):

  File "app2.py", line 2, in <module>

    import mysql.connector

  File "/usr/local/lib/python3.6/site-packages/mysql/connector/__init__.py", line 32, in <module>

    from .connection_cext import CMySQLConnection

  File "/usr/local/lib/python3.6/site-packages/mysql/connector/connection_cext.py", line 40, in <module>

    from .abstracts import MySQLConnectionAbstract

  File "/usr/local/lib/python3.6/site-packages/mysql/connector/abstracts.py", line 33

    from __future__ import annotations

    ^

SyntaxError: future feature annotations is not defined

这个问题可能是由于Python版本的差异导致的。在较旧的Python版本中，如Python 3.6，未来特性注解（future feature annotations）尚未被支持。

因为是在云服务器运行，要使用命令行将Python版本升级到3.7或更高版本比较困难。

后面发现了一种比较好的解决办法

1. 将

import mysql.connector

改成

import pymysql

2.将

conn = mysql.connector.connect(
        host='xxx.xxx.xxx.xxx',
        user='xxx',
        password='xxx',
        database='xxx'
    )

改成

​
conn = pymysql.connect(
        host='xxx.xxx.xxx.xxx',
        user='xxx',
        password='xxx',
        database='xxx'
    )

​

就能顺利运行了。