python mysql keyerror： 255

学习爬虫 ---- mysql的连接问题

使用python访问PyMySql（0.7.9）出现问题：keyerror： 255，字符集相关错误

Traceback (most recent call last):
  File "mysql_demo1.py", line 5, in <module>
    user='root', password=None, db='mysql')
  File "/Users/bianlin/opt/anaconda3/envs/study/lib/python3.6/site-packages/pymysql/__init__.py", line 90, in Connect
    return Connection(*args, **kwargs)
  File "/Users/bianlin/opt/anaconda3/envs/study/lib/python3.6/site-packages/pymysql/connections.py", line 688, in __init__
    self.connect()
  File "/Users/bianlin/opt/anaconda3/envs/study/lib/python3.6/site-packages/pymysql/connections.py", line 905, in connect
    self._get_server_information()
  File "/Users/bianlin/opt/anaconda3/envs/study/lib/python3.6/site-packages/pymysql/connections.py", line 1231, in _get_server_information
    self.server_charset = charset_by_id(lang).name
  File "/Users/bianlin/opt/anaconda3/envs/study/lib/python3.6/site-packages/pymysql/charset.py", line 38, in by_id
    return self._by_id[id]
KeyError: 255

升级PyMySql可以解决问题

(study) ➜  web_scraping pip install --upgrade PyMySql
Collecting PyMySql
  Downloading https://files.pythonhosted.org/packages/4f/52/a115fe175028b058df353c5a3d5290b71514a83f67078a6482cff24d6137/PyMySQL-1.0.2-py3-none-any.whl (43kB)
    100% |████████████████████████████████| 51kB 216kB/s 
Installing collected packages: PyMySql
  Found existing installation: PyMySQL 0.7.9
    Uninstalling PyMySQL-0.7.9:
      Successfully uninstalled PyMySQL-0.7.9
Successfully installed PyMySql-1.0.2
You are using pip version 9.0.1, however version 21.0.1 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.

目前是可以了

(study) ➜  web_scraping python mysql_demo1.py
---- <pymysql.connections.Connection object at 0x7fb21f34e7f0>