pip安装sqlalchemy和mysql-connector的问题解决

最近跟着廖雪峰老师官网教程学习python，到安装sqlalchemy和mysql-connector时遇到一些问题，找了好久在stactoverflow上看到了，这里记录一下。
1.安装sqlalchemy时提示如下错误：
UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xa1 in position 61: invalid start byte

解决方法：
打开 \python36\lib\site-packages\pip\compat__init__.py
修改75行return s.decode('utf_8') 为return s.decode('cp936'),之后再执行pip install sqlalchemy就不报错了。
也可以在cmd上使用chcp对内码表更改。chcp使用方法

2.pip install mysql-connector时如下报错：
C:\Users\Dunxe>pip install mysql-connector
Collecting mysql-connector
Using cached mysql-connector-2.2.3.zip
Building wheels for collected packages: mysql-connector
Running setup.py bdist_wheel for mysql-connector ... error
Complete output from command "e:\program files\python36\python.exe" -u -c "import setuptools, tokenize;__file__='C:\\Users\\Dunxe\\AppData\\Local\\Temp\\pip-build-c276tz29\\mysql-connector\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d C:\Users\Dunxe\AppData\Local\Temp\tmph4ndslzkpip-wheel- --python-tag cp36:
running bdist_wheel
running build
running build_py
creating build
creating build\lib.win-amd64-3.6
creating build\lib.win-amd64-3.6\mysql
copying lib\mysql\__init__.py -> build\lib.win-amd64-3.6\mysql
creating build\lib.win-amd64-3.6\mysql\connector
copying lib\mysql\connector\abstracts.py -> build\lib.win-amd64-3.6\mysql\connector
…
running build_ext
# Python architecture: 64-bit
# Python ARCH_64BIT: True
Unable to find Protobuf include directory.

----------------------------------------`

Command ""e:\program files\python36\python.exe" -u -c "import setuptools, tokenize;__file__='C:\\Users\\Dunxe\\AppData\\Local\\Temp\\pip-build-c276tz29\\mysql-connector\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\Dunxe\AppData\Local\Temp\pip-c_b86yus-record\install-record.txt --single-version-externally-managed --compile" failed with error code 1 in C:\Users\Dunxe\AppData\Local\Temp\pip-build-c276tz29\mysql-connector\

解决方法：安装旧版本的mysql-connector
pip install mysql-connector==2.1.3

---