https://stackoverflow.com/questions/51146117/installing-mysqlclient-in-python-3-6-in-windows

22 7

I want to install MySqlclient on my windows system. I am Currently using Python 3.6. After going through the various post over Stackoverflow, I could Not find the correct way. This is what I have done so far:

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

1) Installation by using pip pip install mysqlclient. Error:

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

I already have Microsoft Visual C++ installed on my laptop. Some are saying you need 2015 edition.

2) Installation by using wheel file pip install mysqlclient-1.3.13-cp36-cp36m-win_amd64.whl. Error:

Requirement mysqlclient-1.3.13-cp36-cp36m-win_amd64.whl looks like a filename, but the file does not exist. mysqlclient-1.3.13-cp36-cp36m-win_amd64.whl is not a supported wheel on this platform.

2.1) Changing the whl file to different version pip install mysqlclient-1.3.13-cp36-cp36m-win32.whl. Error:

Could not install packages due to an EnvironmentError: [Errno 2] No such file or directory: 'C:\\Users\\Foxtrot\\Desktop\\finaltest\\mysqlclient-1.3.13-cp36-cp36m-win32.whl'

Other things that are done: updated setuptools, updated wheel.

python  pip  mysql-python  python-wheel share improve this questionfollow edited Jan 23 '19 at 11:59 Installing mysqlclient in Python 3.6 in windows Python 第1张 Wtower 13.3k1010 gold badges8282 silver badges6767 bronze badges asked  Jul 3 '18 at 3:06 Installing mysqlclient in Python 3.6 in windows Python 第2张 Damian 26511 gold badge22 silver badges77 bronze badges add a comment

9 Answers

Active Oldest Votes 8  

I can't find mysqlclient-1.3.13's whl file on PyPi. So you need to compile it from source. Unfortunately it's not easy. I'm not Windows guy, so I only can recommend guide like this

share improve this answerfollow answered  Jul 3 '18 at 7:38 Installing mysqlclient in Python 3.6 in windows Python 第3张 3sky 68044 silver badges1313 bronze badges add a comment Installing mysqlclient in Python 3.6 in windows Python 第4张 Imagine yourself at WorkBoard Inc. View all job openings! 34

Had the same problem, searched the web etc. Here this answer:

mysql-python install error: Cannot open include file 'config-win.h'

It has all the instructions. In short go to this site: https://www.lfd.uci.edu/~gohlke/pythonlibs/#mysqlclient:

There you will find mysqlclient‑1.3.13‑cp36‑cp36m‑win32.whl mysqlclient‑1.3.13‑cp36‑cp36m‑win_amd64.whl

Download the correct file for your platform.

Then use your downloaded wheels file with pip and your done:

pip install c:\mysqlclient‑1.3.13‑cp36‑cp36m‑win_amd64.whl

The https://www.lfd.uci.edu/~gohlke/pythonlibs has lots of lots of compiled libaries to solve the problem of building them from source yourself. They even compile them for python 3.7 :)

Alternative Solution

You can also download Visual C++ Build Tools and then you should be able to install every (at least to my knowledge) version of mysqlclient with pip. To do this go to this site: https://www.scivision.co/python-windows-visual-c++-14-required/ there you can find out which version of Build Tools you need and you can also find a link to download the installer. Be aware though Build Tools require more than 4GB of free disk space.

share improve this answerfollow edited Dec 12 '18 at 10:28     answered  Jul 3 '18 at 23:44 Installing mysqlclient in Python 3.6 in windows Python 第5张 CodeSamurai777 2,68422 gold badges1515 silver badges3232 bronze badges
  •   Such an easy fix. I would have spent hours spinning on getting mysqlclient installed. Thanks for finding / posting. – raider33 Jul 26 '18 at 1:49
  •   I have the same problem but still, there's an error saying, " Requirement 'mysqlclient-1.3.13-cp37-cp37m-win_amd64.whl' looks like a filename, but the file does not exist mysqlclient-1.3.13-cp37-cp37m-win_amd64.whl is not a supported wheel on this platform." – Irene Jul 31 '18 at 13:02
  • 4 There are wheels available for the previous release 1.3.12. You can install it with pip install "mysqlclient==1.3.12". – Alasdair Aug 17 '18 at 13:11 
  •   The first solution seems to be taken care of by just doing: python -m pip install mysqlclient – Will Ward Jan 18 '19 at 5:05 
  •   I wish there was a way to pin this...this is required for django 2.2.6 > releases when using mysql -_- – hpca01 Oct 23 '19 at 16:55
show 1 more comment 6

I am using python3.7 on Windows 10 operating system. I had same issue and after a long research I had installed it successfully.

Install "Microsoft Visual C++ Build Tools" AND My OS is having 64 bit operating system but still then it need to install 32 bit version "mysqlclient‑1.4.2‑cp37‑cp37m‑win32.whl"

Download binary wheels from "https://www.lfd.uci.edu/~gohlke/pythonlibs/" and run command

pip install [path_to_downloaded_file] eg: C:\Users\Ds\mysqlclient-1.4.2-cp37-cp37m-win32.whl

use pipenv instead of pip if you are using virtual environment.

share improve this answerfollow answered  Jul 21 '19 at 15:42 Installing mysqlclient in Python 3.6 in windows Python 第6张 Dinesh Sharma 7111 silver badge33 bronze badges add a comment 5

The error means that the package has not yet been compiled for your versions of OS and Python. So pip tries to build it from the source for you.

There are two possible solutions.

  1. The first option is to install the most recent version of Microsoft Visual C++ Build Tools. Just go ahead and download it from the Microsoft website. Then pip should be able to compile the package.

  2. Another option is using an unofficial binary. As mentioned here, a resource proved to be useful is https://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python . Just download the pre-compiled package and install it using

    pip install c:\path-to-a-pre-compiled-package

share improve this answerfollow answered  Aug 10 '18 at 13:14 Installing mysqlclient in Python 3.6 in windows Python 第7张 Ildar Akhmetov 99966 silver badges1414 bronze badges add a comment 2

Tell pip not to use sources and use binary packages instead:

pip install --only-binary :all: mysqlclient

https://pip.pypa.io/en/stable/reference/pip_install/#install-only-binary

share improve this answerfollow  
扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄