如何修复KeyError:255 pyMySQL新字符集问题

Question

您好，我正在尝试使用AWS RDS mysql连接SQLAlchemy和Flask，但每当我向数据库发出请求时，我都会收到错误键Error 255

我读了Pull Request 591

这是我的SQLALCHEMY\u数据库\u URI路径

 SQLALCHEMY_DATABASE_URI'mysql+pymysql://admin:password4@admin.rds.amazonaws.com/admin?charset=utf8mb4'

---

connection = pool._invoke_creator(self)
  File "/Users/arthurdecker/Sites/TcwlAPI/restful/venv/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 105, in connect
    return dialect.connect(*cargs, **cparams)
  File "/Users/arthurdecker/Sites/TcwlAPI/restful/venv/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 393, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/Users/arthurdecker/Sites/TcwlAPI/restful/venv/lib/python3.8/site-packages/pymysql/__init__.py", line 90, in Connect
    return Connection(*args, **kwargs)
  File "/Users/arthurdecker/Sites/TcwlAPI/restful/venv/lib/python3.8/site-packages/pymysql/connections.py", line 706, in __init__
    self.connect()
  File "/Users/arthurdecker/Sites/TcwlAPI/restful/venv/lib/python3.8/site-packages/pymysql/connections.py", line 931, in connect
    self._get_server_information()
  File "/Users/arthurdecker/Sites/TcwlAPI/restful/venv/lib/python3.8/site-packages/pymysql/connections.py", line 1269, in _get_server_information
    self.server_charset = charset_by_id(lang).name
  File "/Users/arthurdecker/Sites/TcwlAPI/restful/venv/lib/python3.8/site-packages/pymysql/charset.py", line 38, in by_id
    return self._by_id[id]
KeyError: 255