Installing python-mysql with wamp's mysql

Question

Hello,

(I'm not sure if this should be asked here or SU.. but seeing this question on SO, I am asking it here...)

I have wamp (mysql-5.1.33) server setup on my vista machine, and I am trying to install python-mysql 1.2.3c1 to use the mysql version provided by wamp.

At first, when I ran python setup.py install, I got an error saying it couldn't find the location of the mysql's bin folder. Looking into setup_windows.py, I noticed it was looking for a registry key and so I added that registry entry and I think it is able to find it now.

But now, when I run python setup.py install, I get a different error saying Unable to find vcvarsall.bat.

Any help on installing this appreciated.

Here is the output of python setup.py install:

running install
running bdist_egg
running egg_info
writing MySQL_python.egg-info\PKG-INFO
writing top-level names to MySQL_python.egg-info\top_level.txt
writing dependency_links to MySQL_python.egg-info\dependency_links.txt
reading manifest file 'MySQL_python.egg-info\SOURCES.txt'
reading manifest template 'MANIFEST.in'
writing manifest file 'MySQL_python.egg-info\SOURCES.txt'
installing library code to build\bdist.win32\egg
running install_lib
running build_py
copying MySQLdb\release.py -> build\lib.win32-2.6\MySQLdb
running build_ext
building '_mysql' extension
error: Unable to find vcvarsall.bat

Thanks a lot!

Answer 1

It is looking for the Microsoft Visual Studio compiler to take care of some (presumably) C libraries.

You need to install Visual Studio, or perhaps MINGW.

Answer 2

You can use a precompiled binary available at sourceforge page of mysql-python. The version 1.2.2 has the binary installer for python2.4 and python2.5

If you are searching for python2.6 binaries, find it here - http://www.codegood.com/archives/4