pip install mysqlclient : Microsoft Visual C++ 14.0 is required

Question

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

You need to install the specified version, not 2015. Microsoft Visual C++ 14.0 instead. — wrivas
– wrivas, Commented Jun 27, 2018 at 13:26
Are you sure you've installed Build Tools and not Redistributable package? — phd
– phd, Commented Jun 27, 2018 at 16:22
To install a Python DB API driver for MySQL you can try mysql-connector or PyMySQL. — phd
– phd, Commented Jun 27, 2018 at 16:26
i think i've installed the correct one, can you give me the correct link? — Gargantua
– Gargantua, Commented Jun 28, 2018 at 7:22

Debashish D. Dev · Accepted Answer · 2020-11-16 05:59:38Z

44

You may need to install the Python 3 and MySQL development headers and libraries like so: For UBUNTU or Debian

sudo apt-get install python3-dev default-libmysqlclient-dev build-essential

Red Hat / CentOS

sudo yum install python3-devel mysql-devel

Then try

pip install mysqlclient

answered Nov 16, 2020 at 5:59

Debashish D. Dev

5491 gold badge4 silver badges3 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

WiR3D Over a year ago

Just a note: if you are doing this in a docker container, then you also likely need to install gcc

CertainPerformance · Accepted Answer · 2018-08-10 06:37:00Z

18

First install python 3.6.5, then run

pip install mysqlclient==1.3.12

edited Aug 10, 2018 at 6:37

CertainPerformance

373k55 gold badges354 silver badges359 bronze badges

answered Aug 10, 2018 at 6:19

Bishu rudra paul

2041 silver badge4 bronze badges

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

6

Try download and install from wheel instead. Take note of your python version and download the correct one.

https://www.lfd.uci.edu/~gohlke/pythonlibs/#mysqlclient

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Aug 9, 2018 at 7:00

Lai Niel

1115 bronze badges

3 Comments

Philipp Maurer Over a year ago

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review

anothernode Over a year ago

@PhilippMaurer That link is not a link to an answer but just to the download. The answer is the sentence before the link. It might not be a great one, it might not even be correct, I don't know, but it is an answer and should not be flagged as not being one.

Asad Shakeel Over a year ago

I'll explain a bit here... if you are using python3.7 you should download mysqlclient‑1.4.2‑cp37‑cp37m‑win32.whl for 32-bit window. and same for python3.5 => mysqlclient‑1.4.2‑cp35‑cp35m‑win_amd64.whl for 64-bit windows. here you can compare cp number with python version. for your windows type

Sayse · Accepted Answer · 2019-11-27 15:47:09Z

6

For me, it was a mixture of an old setup tools and missing packages

pip install --upgrade setuptools

apt install gcc libssl-dev

answered Nov 27, 2019 at 15:47

Sayse

43.4k14 gold badges85 silver badges150 bronze badges

Comments

tlentali · Accepted Answer · 2021-07-29 12:28:31Z

6

Install below packages and it will resolve the issue.

apt-get install python3-dev default-libmysqlclient-dev build-essential

edited Jul 29, 2021 at 12:28

tlentali

3,4632 gold badges18 silver badges23 bronze badges

answered Jul 29, 2021 at 11:36

Ritesh Kumar Sahu

691 silver badge1 bronze badge

Comments

Vince D · Accepted Answer · 2019-02-16 14:23:26Z

3

Try pip install --only-binary :all: mysqlclient Worked for me

answered Feb 16, 2019 at 14:23

Vince D

1373 silver badges14 bronze badges

1 Comment

alhelal Over a year ago

shows " Could not find a version that satisfies the requirement mysqlclient (from versions: ) No matching distribution found for mysqlclient "

Ashish Nandan · Accepted Answer · 2019-11-19 10:56:17Z

First try this command

(keep space properly ie, pip space install space --only-binary space :all: space mysqlclient)

pip install --only-binary :all: mysqlclient if still error then try this... Go to this website Python Extension package and press ctrl+F and search mysqlclient. You will find a file name like this.. mysqlclient‑1.4.5‑cp38‑cp38‑win_amd64.whl

Choose carefully ---According to python version There is a step given to choose it.

cp38 means for python 3.8 version and cp 37 means for python 3.6 version so first check your python version wether it is 3.8,3.7,3.6,3.5,3.4 then download accordingly.
amd64--- while checking python version also check whether your python is of 64-bit or 32-bit. then select accordingly. If your python is of 32-bit then select amd32.

Otherwise you will face problem. Then download the file and install it manually using pip command. There are steps given below:-

After download open command prompt and go to that directory where that downloaded file available( or better to cut that file and paste into your desktop) and type: NOTE :- PLEASE TYPE AFTER DOWNLOAD THE FILE... This is for python 3.8 and 64-bit $ pip install mysqlclient‑1.4.5‑cp38‑cp38‑win_amd64.whl For python 3.7 and 32-bit $ pip install mysqlclient‑1.4.5‑cp37‑cp37m‑win32.whl

yiming tian · Accepted Answer · 2020-06-16 07:02:26Z

1

You can set ssl library path explicitly.

LDFLAGS=-L/usr/local/opt/openssl/lib pip install mysqlclient

answered Jun 16, 2020 at 7:02

yiming tian

211 bronze badge

Comments

Sunderam Dubey · Accepted Answer · 2022-07-26 15:55:21Z

1

I had look a like problem, on MacOs Catalina, solved with this:

ARCHFLAGS="-arch x86_64" pip3 install mysqlclient

edited Jul 26, 2022 at 15:55

Sunderam Dubey

8,83512 gold badges25 silver badges43 bronze badges

answered Jan 31, 2022 at 11:19

oruchkin

1,3031 gold badge15 silver badges26 bronze badges

1 Comment

Shm Over a year ago

I tried EVERYTHING and nothing worked for me except for this.

Ashish Nandan · Accepted Answer · 2019-11-19 18:34:56Z

0

Better if you install python 64-bit. Then pip install mysqlclient will work sure otherwise you can follow these stepssteps to install using python extension packages

answered Nov 19, 2019 at 18:34

Ashish Nandan

404 bronze badges

Comments

ayamdobhal · Accepted Answer · 2020-04-08 15:34:02Z

0

Install build-essential

sudo apt-get install build-essential
Install mysqlclient

pip install mysqlclient

edited Apr 8, 2020 at 15:34

ayamdobhal

337 bronze badges

answered Mar 18, 2020 at 8:12

Ankit Chaurasia

1044 bronze badges

1 Comment

Michael Nelles Over a year ago

This is for Ubuntu - can you post the centos version also please

discover · Accepted Answer · 2022-07-18 09:50:11Z

-1

This happened to me when I installed python3.8 from deadsnakes/ppa repository and created virtualenv using it.

Above solutions didn't work for me and after installing python3.8-dev it is installed successfully.

sudo apt install python3.8-dev

After that

python3.8 -m pip install mysqlclient==1.3.12

edited Jul 18, 2022 at 9:50

answered Jun 24, 2022 at 8:46

discover

6091 gold badge9 silver badges18 bronze badges

Comments

Evgeni Genchev · Accepted Answer · 2020-06-26 15:45:18Z

-2

I had the same problem and I fixed in a really stupid way. I just uninstalled python and installed it through the Microsoft Store.

answered Jun 26, 2020 at 15:45

Evgeni Genchev

476 bronze badges

Collectives™ on Stack Overflow

pip install mysqlclient : Microsoft Visual C++ 14.0 is required

13 Answers 13

1 Comment

Comments

3 Comments

Comments

Comments

1 Comment

Comments

Comments

1 Comment

Comments

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

13 Answers 13

1 Comment

Comments

3 Comments

Comments

Comments

1 Comment

Comments

Comments

1 Comment

Comments

1 Comment

Comments

Comments

Linked

Related