Python error: command '…\Microsoft Visual Stud

Question

I have some problems with python 3 module installing. I'm trying to install mysql using pip :

python -m pip install mysql

for python 3.4.4 and here is the error I get:

error: command 'C:\\Program Files (x86\\Microsoft Visual Studio 10.0\\VC\\BIN\\cl.exe' failed with exit status 2

here is a screenshot : screenshot of the error message

I had other problems with module installation before, and I solved those by installing Visual Studio C++ 2010

Btw, the installation of other modules are working just fine.

My specs : Windows 10 x64

Python 3.4.4 x86

Answer 1

Go to this site and download whl file (for example python3.7 and win64 should use mysqlclient-1.3.13-cp37-cp37m-win_amd64.whl).

Then run this command:

python -m pip install C:\Users\%USER%\Desktop\mysqlclient-1.3.13-cp37-cp37m-win_amd64.whl

Answer 2

Do you have Connector installed? (See also here)

Download it here and install.

It can be due to you have x64 Windows, but mysql wants files to be in "Program Files (x86)" directory:

mklink /d "C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include" "C:\Program Files\MySQL\MySQL Connector C 6.0.2\include"

If won't help, try other answers from that post