sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1043, ‘Bad handshake’)

发表于   |   分类于   |   阅读次数 3,267

mysql新版本的问题，旧的驱动不支持新的mysql的验证方式引起的。需要更新对应的PyMySQL版本到最新或者较新：

pip install PyMySQL  -i https://pypi.tuna.tsinghua.edu.cn/simple some-package
Looking in indexes: https://pypi.tuna.tsinghua.edu.cn/simple
Requirement already satisfied: PyMySQL in ./venv/lib/python3.7/site-packages (0.7.11)
Requirement already satisfied: some-package in ./venv/lib/python3.7/site-packages (0.1)
(venv) ➜  spug_api git:(master) ✗ pip install PyMySQL==0.9.3  -i https://pypi.tuna.tsinghua.edu.cn/simple some-package
Looking in indexes: https://pypi.tuna.tsinghua.edu.cn/simple
Collecting PyMySQL==0.9.3
  Using cached https://pypi.tuna.tsinghua.edu.cn/packages/ed/39/15045ae46f2a123019aa968dfcba0396c161c20f855f11dea6796bcaae95/PyMySQL-0.9.3-py2.py3-none-any.whl
Requirement already satisfied: some-package in ./venv/lib/python3.7/site-packages (0.1)
Installing collected packages: PyMySQL
  Found existing installation: PyMySQL 0.7.11
    Uninstalling PyMySQL-0.7.11:
      Successfully uninstalled PyMySQL-0.7.11
Successfully installed PyMySQL-0.9.3

发表评论