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, Jun 27 '18 at 13:26
Are you sure you've installed **Build Tools** and not **Redistributable** package? — phd, Jun 27 '18 at 16:22
To install a Python DB API driver for MySQL you can try `mysql-connector` or `PyMySQL`. — phd, Jun 27 '18 at 16:26
i think i've installed the correct one, can you give me the correct link? — Gargantua, Jun 28 '18 at 07:22
I didn't resolved this problem but i managed to find another library that need no intallation import pymysql — Gargantua, Jun 28 '18 at 14:48

score 44 · Answer 1 · answered Nov 16 '20 at 05:59

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 '20 at 05:59

Debashish D. Dev

549
1
4
3

Just a note: if you are doing this in a docker container, then you also likely need to install `gcc` – WiR3D Feb 18 '22 at 07:55

score 18 · Accepted Answer · edited Aug 10 '18 at 06:37

18

First install python 3.6.5, then run

pip install mysqlclient==1.3.12

edited Aug 10 '18 at 06:37

CertainPerformance

356,069
52
309
320

answered Aug 10 '18 at 06:19

Bishu rudra paul

204
1
4

score 6 · Answer 3 · edited Jun 20 '20 at 09:12

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 '20 at 09:12

Community

1
1

answered Aug 09 '18 at 07:00

Lai Niel

111
5

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](/review/low-quality-posts/20539483) – Philipp Maurer Aug 09 '18 at 07:59
@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](https://meta.stackoverflow.com/questions/287563/youre-doing-it-wrong-a-plea-for-sanity-in-the-low-quality-posts-queue). – anothernode Aug 09 '18 at 08:22
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 – Asad Shakeel Jul 03 '19 at 11:41

score 6 · Answer 4 · answered Nov 27 '19 at 15:47

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 '19 at 15:47

Sayse

42,633
14
77
146

score 6 · Answer 5 · edited Jul 29 '21 at 12:28

6

Install below packages and it will resolve the issue.

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

edited Jul 29 '21 at 12:28

tlentali

3,407
2
14
21

answered Jul 29 '21 at 11:36

Ritesh Kumar Sahu

69
1
1

score 3 · Answer 6 · answered Feb 16 '19 at 14:23

3

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

answered Feb 16 '19 at 14:23

Vince D

137
3
14

1

shows " Could not find a version that satisfies the requirement mysqlclient (from versions: ) No matching distribution found for mysqlclient " – alhelal Feb 16 '20 at 06:38

Ashish Nandan · Answer 7 · 2019-11-19T10:56:17.740

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

score 1 · Answer 8 · answered Jun 16 '20 at 07:02

1

You can set ssl library path explicitly.

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

answered Jun 16 '20 at 07:02

yiming tian

21
1

score 1 · Answer 9 · edited Jul 26 '22 at 15:55

1

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

ARCHFLAGS="-arch x86_64" pip3 install mysqlclient

edited Jul 26 '22 at 15:55

Sunderam Dubey

1
11
20
40

answered Jan 31 '22 at 11:19

oruchkin

1,145
1
10
21

2

I tried EVERYTHING and nothing worked for me except for this. – Shm Jul 25 '22 at 20:48

score 0 · Answer 10 · answered Nov 19 '19 at 18:34

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 '19 at 18:34

Ashish Nandan

40
4

score 0 · Answer 11 · edited Apr 08 '20 at 15:34

0

Install build-essential

sudo apt-get install build-essential
Install mysqlclient

pip install mysqlclient

edited Apr 08 '20 at 15:34

AyamDobhal

33
7

answered Mar 18 '20 at 08:12

Ankit Chaurasia

94
4

This is for Ubuntu - can you post the centos version also please – Michael Nelles Mar 18 '20 at 08:54

discover · Answer 12 · 2022-07-18T09:50:11.103

-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 '22 at 09:50

answered Jun 24 '22 at 08:46

discover

411
1
6
16

score -2 · Answer 13 · answered Jun 26 '20 at 15:45

-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 '20 at 15:45

Evgeni Genchev

37
5

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

13 Answers13

Linked

Related