python 连接 mysql 数据库出现 keyerror 255 错误

python 连接 mysql 数据库出现 keyerror： 255，字符集相关错误

Traceback (most recent call last):

  File "<ipython-input-13-850297a5d287>", line 1, in <module>
    mydata = con_mysql(sql)

  File "<ipython-input-12-4a07bff92d12>", line 3, in con_mysql
    ,port = port,db = dbname,charset="utf8")

  File "D:\Programfiles\Anaconda3\lib\site-packages\pymysql\__init__.py", line 90, in Connect
    return Connection(*args, **kwargs)

  File "D:\Programfiles\Anaconda3\lib\site-packages\pymysql\connections.py", line 706, in __init__
    self.connect()

  File "D:\Programfiles\Anaconda3\lib\site-packages\pymysql\connections.py", line 931, in connect
    self._get_server_information()

  File "D:\Programfiles\Anaconda3\lib\site-packages\pymysql\connections.py", line 1269, in _get_server_information
    self.server_charset = charset_by_id(lang).name

  File "D:\Programfiles\Anaconda3\lib\site-packages\pymysql\charset.py", line 38, in by_id
    return self._by_id[id]

KeyError: 255

参考文章 PyMySQL KeyError:255_keyerror: 255-CSDN博客 打开cmd，更新 PyMySQL包，不再报错：

> pip install --upgrade PyMySQL
Collecting PyMySQL
  Downloading https://files.pythonhosted.org/packages/ed/39/15045ae46f2a123019aa968dfcba0396c161c20f855f11dea6796bcaae95/PyMySQL-0.9.3-py2.py3-none-any.whl (47kB)
    100% |████████████████████████████████| 51kB 110kB/s
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