pip安装 mysql 客户端,pip安装mysqlclient错误

i'm tryng to import mysqlclient library for python with pip, when i use the command

pip install mysqlclient it return an error:

Collecting mysqlclient

Using cached https://files.pythonhosted.org/packages/ec/fd/83329b9d3e14f7344d1cb31f128e6dbba70c5975c9e57896815dbb1988ad/mysqlclient-1.3.13.tar.gz

Installing collected packages: mysqlclient

Running setup.py install for mysqlclient ... error

Complete output from command c:\users\astrina\appdata\local\programs\python\python36\python.exe -u -c "import setuptools, tokenize;__file__='C:\\Users\\astrina\\AppData\\Local\\Temp\\pip-install-40l_x_f4\\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:\Users\astrina\AppData\Local\Temp\pip-record-va173t5v\install-record.txt --single-version-externally-managed --compile:

c:\users\astrina\appdata\local\programs\python\python36\lib\distutils\dist.py:261: UserWarning: Unknown distribution option: 'long_description_content_type'

warnings.warn(msg)

running install

running build

running build_py

creating build

creating build\lib.win-amd64-3.6

copying _mysql_exceptions.py -> build\lib.win-amd64-3.6

creating build\lib.win-amd64-3.6\MySQLdb

copying MySQLdb\__init__.py -> build\lib.win-amd64-3.6\MySQLdb

copying MySQLdb\compat.py -> build\lib.win-amd64-3.6\MySQLdb

copying MySQLdb\connections.py -> build\lib.win-amd64-3.6\MySQLdb

copying MySQLdb\converters.py -> build\lib.win-amd64-3.6\MySQLdb

copying MySQLdb\cursors.py -> build\lib.win-amd64-3.6\MySQLdb

copying MySQLdb\release.py -> build\lib.win-amd64-3.6\MySQLdb

copying MySQLdb\times.py -> build\lib.win-amd64-3.6\MySQLdb

creating build\lib.win-amd64-3.6\MySQLdb\constants

copying MySQLdb\constants\__init__.py -> build\lib.win-amd64-3.6\MySQLdb\constants

copying MySQLdb\constants\CLIENT.py -> build\lib.win-amd64-3.6\MySQLdb\constants

copying MySQLdb\constants\CR.py -> build\lib.win-amd64-3.6\MySQLdb\constants

copying MySQLdb\constants\ER.py -> build\lib.win-amd64-3.6\MySQLdb\constants

copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win-amd64-3.6\MySQLdb\constants

copying MySQLdb\constants\FLAG.py -> build\lib.win-amd64-3.6\MySQLdb\constants

copying MySQLdb\constants\REFRESH.py -> build\lib.win-amd64-3.6\MySQLdb\constants

running build_ext

building '_mysql' extension

error: Microsoft Visual C++ 14.0 is required. Get it with "Microsoft Visual C++ Build Tools": http://landinghub.visualstudio.com/visual-cpp-build-tools

----------------------------------------

Command "c:\users\astrina\appdata\local\programs\python\python36\python.exe -u -c "import setuptools,

tokenize;__file__='C:\\Users\\astrina\\AppData\\Local\\Temp\\pip-install-

40l_x_f4\\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:\Users\astrina\AppData\Local\Temp\pip-

record-va173t5v\install-record.txt --single-version-externally-managed --

compile" failed with error code 1 in C:\Users\astrina\AppData\Local\Temp\pip-

install-40l_x_f4\mysqlclient\

I've already installed Microsoft Build Tools 2015 but the problem persist

解决方案

First install python 3.6.5, then run

pip install mysqlclient==1.3.12