个人环境是 python2.7,sqlalchemy1.1.6,mysql5.7.18,mysql-python1.2.5。
在pycharm中准备用sqlalchemy连接本地的数据库,连接的代码是:
engine = create_engine("mysql+mysqldb://root:root@localhost:3306/test?charset=utf8mb4")
DBSession = sessionmaker(bind=engine)
session = DBsession()
#执行一段查询
res = session.execute("select * from testTable where id = '11' ").fetchall()
然后报错是sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (2019, "Can't initialize character set utf8mb4 (path: C:\mysql\\share\charsets\)")