Install mysql-python (Windows)

Question 1

I've spent hours trying to make Django work on my computer. The problem is that I can't install the mysql-python package. I'm running Windows 7 64bit. This is what I've tried:

I have downloaded easy_install
I have downloaded Cygwin64 to be able to run Linux commands (Win cmd was driving me crazy)
I have typed in: easy_install mysql-python (gave me an error message saying it can't find vcvarsall.bat)
I have downloaded Visual Studio 2010. However, I uninstalled it since I found out that I had some other version of it already (it didn't solve the problem)

EDIT: I discovered this: https://pypi.python.org/pypi/MySQL-python/1.2.5. Does this mean I can't run Django with python 3.3? And why bother to go through all this work if there is an .exe-file out there?

Question 2

install PIP pip-installer.org/en/latest/installing.html and use this to install packages. Also make sure that all the python files that you are running are added to your Path environment variable. That may be why it says that "vcvarsall.bat" is not found. You should be able to use MySQL / Django / Python 3.3 fine with no issues. They are all supported and work together.

Question 3

Thanks Aron! I have now downloaded PIP. However, I get the exact same error message when typing: pip install mysql-python. What python files do you mean I need to add to my path?

Question 4

Please see my answer below. That should get MySQL running for you.

Question 5

try running the following command:

pip install mysqlclient

Question 6

this is the easiest solution and worked out of the box. it should be the top answer.

Question 7

If using PyCharm, you can install mysqlclient directly through the Project Interpreter window.

Question 8

I'm pretty sure the OP's problem is that pip install mysqlclient was throwing a bunch of errors. I went through the same thing with VS 2015 and it took me like 5 hours to find the root cause, which was a variety of things, which included needing to update setuptools, update easyinstall, update pip, install wheel, and install c++2010 and change the path of my virtual env to a shorter length. then i found installying a lower version of mysqlclient works in a different env so it was crazy

Question 9

This was the easiest answer for Anaconda Navigator 3.6 Python

Question 10

Another possible solution for this under stackoverflow.com/a/51811349/1552410

Question 11

If you are trying to use mysqlclient on WINDOWS with this failure, try to install the lower version instead:

pip install mysqlclient==1.3.4

Question 12

I get the error "Failed building wheel for mysqlclient" and answer of Laura Chesches worked for me.

Question 13

this fixed it for me. I needed mysqldb for QGIS plugin, which runs python 2.7 (support for older plugins) at the time of my install. (early 2018)

Question 14

FYI, this works b/c 1.3.4 is precompiled into a wheel, newer versions only have the source

Question 15

thank you. this worked for me on python 2.7 in pycharm. no other solutions, like pip install mysql-python worked for me.

Question 16

if you use the site http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python , download the file:

mysqlclient‐1.3.6‐cp34‐none‐win32.whl or
mysqlclient‐1.3.6‐cp34‐none‐win_amd64.whl

depending on the version of python you have (these are for python 3.4) and the type of windows you have (x64 or x32)

extract this file into C:\Python34\Lib\site-packages and your project will work

Question 17

Or run pip install C:\XX\mysqlclient‐1.3.6‐cpYY‐none‐winZZ.whl

Question 18

this works for me on win7, mysqlclient need to download a vcforpython waste of time..

Question 19

The page you requested was removed.

Question 20

There are windows installers for MySQLdb avaialable for both 32 and 64 bit, supporting Python from 2.6 to 3.4. Check here.

Question 21

I had almost the exact same situation as @Myone described. Manually downloading from this link solved it. No modifications to PYTHONPATH necessary.

Question 22

You're going to want to add Python to your Path Environment Variable in this way. Go to:

My Computer
System Properties
Advance System Settings
Under the "Advanced" tab click the button that says "Environment Variables"
Then under System Variables you are going to want to add / change the following variables: PYTHONPATH and Path. Here is a paste of what my variables look like:

PYTHONPATH

C:\Python27;C:\Python27\Lib\site-packages;C:\Python27\Lib;C:\Python27\DLLs;C:\Python27\Lib\lib-tk;C:\Python27\Scripts

Path

C:\Program Files\MySQL\MySQL Utilities 1.3.5\;C:\Python27;C:\Python27\Lib\site-packages;C:\Python27\Lib;C:\Python27\DLLs;C:\Python27\Lib\lib-tk;C:\Python27\Scripts

Your Path's might be different, so please adjust them, but this configuration works for me and you should be able to run MySQL after making these changes.

Question 23

Thank you for your answer. I didn't have a system variable called PYTHONPATH, but I created one and added what you suggested. I did the same thing with the Path-variable. I have checked that all paths exist on my computer. They all do, except for this one: C:\Python33\Lib\lib-tk. Can't find it. However, I ignored that and restarted my computer. I then tried both "easy_install mysql-python" and "pip install mysql-python". They both generated the same error message about not finding vcvarsall.bat.

Question 24

Oh... so now I downloaded another version of Visual Studio (2010 C++, I think I downloaded another version the other time) and the problem is solved! Well, a part of it. Now it gives me another error message though, that somehow seems related to vcvarsall.bat: File "C:\Python33\Lib\distutils\msvc9compiler.py", line 287, in query_vcvarsall raise ValueError(str(list(result.keys()))) ValueError: ['path']

Question 25

If it's a [Path] error then check your Path again. I don't use Visual Studio with MySQL / Django so I'm not sure if you need that. It might be an extra configuration that you don't need. Did you follow the install PIP instructions in the link? And pip was successfully installed?

Question 26

Hm... yup, I followed the instructions for both pip and easy_install so that shouldn't be the problem. And if you google this problem everyone tells you to download VS. Now I have also tried to add the location of vcvarsall.bat in my path and that didn't help. I've also followed the instructions here: stackoverflow.com/questions/2667069/… and that didn't help either. Feels like I've tried everything... I'm not exactly a computer genius so this is very annoying.

Question 27

way to complicated, just do pip install mysqlclient

Question 28

For folks using Python 3.0+ (which should be everyone now):

Unfortunately, MySQL-Python 1.2.5 does not support Python 3.0+ yet (which is kinda unreasonable IMHO, Python 3+ has been out for a while). Reference : https://pypi.python.org/pypi/MySQL-python/1.2.5

So, my workaround is to use Oracle's MySQL connector. In settings.py, change DATABASE's 'ENGINE' field to: 'ENGINE': 'mysql.connector.django',

More info could be found in the last paragraph of the first answer to this question: Setting Django up to use MySQL

Hope this helps!!

Question 29

Why should everyone be using Python 3.0+ by now?

Question 30

I have a slightly different setup, but think my solution will help you out.

I have a Windows 8 Machine, Python 2.7 installed and running my stuff through eclipse.

Some Background:

When I did an easy install it tries to install MySQL-python 1.2.5 which failed with an error: Unable to find vcvarsall.bat. I did an easy_install of pip and tried the pip install which also failed with a similar error. They both reference vcvarsall.bat which is something to do with visual studio, since I don't have visual studio on my machine, it left me looking for a different solution, which I share below.

The Solution:

Reinstall python 2.7.8 from 2.7.8 from https://www.python.org/download this will add any missing registry settings, which is required by the next install.
Install 1.2.4 from http://pypi.python.org/pypi/MySQL-python/1.2.4

After I did both of those installs I was able to query my MySQL db through eclipse.

Question 31

MySqldb python install windows

MySQL-python 1.2.3 for Windows and Python 2.7, 32bit and 64bit versions

download python mysql-python from here

Question 32

If you encounter the problem with missing MS VC 14 Build tools while trying pip install mysqlclient a possible solution for this may be https://stackoverflow.com/a/51811349/1552410

Question 33

Just Download mysqlclient from here https://www.lfd.uci.edu/~gohlke/pythonlibs/ be careful while downloading the right version depending on your your python version installed. Then proceed with the import. It worked for me because in my case the error was telling to install Visual Studio C++ 14.0 something which wasted my time and occupied around 10GB of space in my C drive. So recommending installing mysqlclient using pip install mysqlclient

Question 34

For phpmydamin you can use following step

Go to python install path like

 cd C:\Users\Enamul\AppData\Local\Programs\Python\Python37-32\Scripts

Run the command pip install PyMySQL
In the python shell import library like import pymysql

connection to databasbe

 db = pymysql.connect(host='localhost',user='root',passwd='yourpassword', database="bd")

get cursor cursor = db.cursor()

Create table like

cursor.execute("CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))")

Ortal Blumenfeld Lagziel 2,5753 gold badges26 silver badges36 bronze badges · Accepted Answer · 2015-07-08 08:31:49Z

90

try running the following command:

pip install mysqlclient

Share

Improve this answer

edited Jun 8, 2017 at 4:50

answered Jul 8, 2015 at 8:31

Ortal Blumenfeld Lagziel's user avatar

Ortal Blumenfeld Lagziel

2,5753 gold badges26 silver badges36 bronze badges

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

6 Comments

user1052080

user1052080 Over a year ago

this is the easiest solution and worked out of the box. it should be the top answer.

2015年10月30日T16:02:29.573Z+00:00

Vlad Schnakovszki

Vlad Schnakovszki Over a year ago

If using PyCharm, you can install mysqlclient directly through the Project Interpreter window.

2017年01月29日T21:05:58.47Z+00:00

Tim

Tim Over a year ago

I'm pretty sure the OP's problem is that pip install mysqlclient was throwing a bunch of errors. I went through the same thing with VS 2015 and it took me like 5 hours to find the root cause, which was a variety of things, which included needing to update setuptools, update easyinstall, update pip, install wheel, and install c++2010 and change the path of my virtual env to a shorter length. then i found installying a lower version of mysqlclient works in a different env so it was crazy

2017年02月06日T17:09:22.11Z+00:00

Murtaza Kanchwala

Murtaza Kanchwala Over a year ago

This was the easiest answer for Anaconda Navigator 3.6 Python

2017年08月14日T07:00:40.997Z+00:00

kaya

kaya Over a year ago

Another possible solution for this under stackoverflow.com/a/51811349/1552410

2018年08月12日T21:34:57.803Z+00:00

|

CollectivesTM on Stack Overflow

Install mysql-python (Windows)

11 Answers 11

6 Comments

4 Comments

3 Comments

1 Comment

10 Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Post as a guest

Linked

Hot Network Questions

CollectivesTM on Stack Overflow

11 Answers 11

6 Comments

4 Comments

3 Comments

1 Comment

10 Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Post as a guest

Linked

Related