pip install mysqlclient

报错

building '_mysql' extension
creating build\temp.win-amd64-3.6
creating build\temp.win-amd64-3.6\Release

...

_mysql.c
_mysql.c(29): fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\BIN\\x86_amd64\\cl.exe' failed with exit status 2
----------------------------------------
ERROR: Command errored out with exit status 1: 'C:\Users\allve\Envs\my36\Scripts\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\allve\\AppData\\Local\\Temp\\pip-install-fywcmeln\\mysqlclient\\setup.py'"'"'; __file__='"'"'C:\\User
s\\allve\\AppData\\Local\\Temp\\pip-install-fywcmeln\\mysqlclient\\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:\Us
ers\allve\AppData\Local\Temp\pip-record-jk0_nk0s\install-record.txt' --single-version-externally-managed --compile --install-headers 'C:\Users\allve\Envs\my36\include\site\python3.6\mysqlclient' Check the logs for full command output.
pip install numpy
pip install mysqlclient