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

I have added to the downloads page two distributions of the mysql-python module 1.2.3 for python 2.7

The distributions are:

  MySQL-python-1.2.3.win32-py2.7.exe (1,023.1 KiB)


  MySQL-python-1.2.3.win-amd64-py2.7.exe (1.0 MiB)

Some quick notes:

  1. The choice of 32bit and 64bit depends on the version of python you have installed in your computer and not in the operating system or the server you want to access. So if you have the 32 bit python 2.7 installed on your 64 bit Windows, you will download and install the 32 bit version.
  2. Some python distributions do not make correct registry entries when they install the 64bit python. If this is the case the 64 bit mysql-python installer will not find your python installation. This means that the 64bit python version has been wrongly set in the registry under the Wow6432Node which is under convention for 32bit software only. You will have to add/move the python registry node in the correct place i.e. in HKEY_LOCAL_MACHINE\SOFTWARE  for more info see my post in sourceforge http://bit.ly/c8J6Yr . If your python is from the official distribution (http://www.python.org)  you will not have this problem.

Following are the results  of the test suite that comes with mysql-python on the newly build distributions (I had to edit the tests in three places to replace deprecated test methods in 2.7  that were giving, for that reason, warnings and subsequently two failures in the test_MySQLdb_capabilities.py)

MySQL-python Windows 64bit and 32bit distributions

UPDATE 19/9/2010: for Python 2.7 look at this post.

I have built two 64bit and two 32bit Windows distributions of the MySQLdb module for Python 2.6.x for both the stable 1.2.2 and the beta 1.2.3c1 versions.

It seems there were no 64bit distribution for Windows (at least for Python 2.6.x) in public and some of the 32bit ones I have tried had not been built with charset support for languages like greek or hebrew (not that I need them since the encoding I use is utf-8).

You can download the distributions from here:

  MySQL-python-1.2.2.win32-py2.6.exe (1,022.8 KiB)

  MySQL-python-1.2.2.win-amd64-py2.6.exe (1.0 MiB)

  MySQL-python-1.2.3c1.win32-py2.6.exe (1,023.2 KiB)

  MySQL-python-1.2.3c1.win-amd64-py2.6.exe (1.0 MiB)

UPDATE – Embedded binaries also available:

For the 64bit embedded versions get:

  MySQL-python-embedded-1.2.2.win-amd64-py2.6.exe (261.0 KiB)

  MySQL-python-embedded-1.2.3c1.win-amd64-py2.6.exe (261.4 KiB)

For the 32bit embedded versions get:

  MySQL-python-embedded-1.2.2.win32-py2.6.exe (231.9 KiB)

  MySQL-python-embedded-1.2.3c1.win32-py2.6.exe (232.3 KiB)

The embedded versions are linked against libmysqld.dll which must be present in the program directory (you will get a dll load fail if it isn’t there) and the share directory must also exist or else the program will crash in MySQLdb.server_init().