MySQL-python Windows 64bit and 32bit distributions

Posted: 22-04-2009 | Author: Ioannis Lalopoulos | Category: Python

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().

Category: Python by Ioannis Lalopoulos

25 Responses to “MySQL-python Windows 64bit and 32bit distributions”

  1. David Woods, on April 23rd, 2009 at 00:12 Said:

    Have you had any luck building Windows distributions that use embedded MySQL? I have not been able to get this to work since the combination of MySQLdb 1.2.0 and MySQL 4.0.25. Any help you could provide would be greatly appreciated.

  2. Ioannis Lalopoulos, on April 23rd, 2009 at 23:38 Said:

    Never tried the embedded build until now.

    The news are good, I just made two succesfull 64bit builds of the embedded server (libmysqld.dll) and finished some tests.

    The build environment consisted of Windows Vista Business 64bit SP1, Python 2.6.2 x64, MySQL 5.1.33 x64, VS2008 Pro SP1 and MySQL-python 1.2.3c1 and 1.2.2.

    I have updated my original post with these 64bit builds and this Saturday will add the 32bit versions.

  3. Nicolas Steinmetz, on May 11th, 2009 at 16:21 Said:

    Thanks for this, I was on the way to start a VM just for this. You saved me a lot of time :)

  4. Christian, on July 4th, 2009 at 08:21 Said:

    Thanks a lot for these! A real lifesaver, Python 2.6 + MySQL on Windows used to be a real pain until I saw this post.

    Cheers!

  5. Arend, on July 4th, 2009 at 21:03 Said:

    Great – I wish I found this site half a day earlier.
    Thanks a lot

  6. Antonio, on July 8th, 2009 at 23:31 Said:

    Thank you for sharing your work!

  7. MySQL-python Windows 64bit and 32bit distributions | Python Developer India, on July 10th, 2009 at 18:25 Said:

    [...] Read more from the original source: MySQL-python Windows 64bit and 32bit distributions [...]

  8. AD, on August 1st, 2009 at 11:38 Said:

    Can you give some help on getting the installer to see the registry path for Python? I’ve checked, its there, but the installer can’t see it.

    Thanks

  9. Tugba, on August 4th, 2009 at 22:30 Said:

    Hi Ioannis, thank you for sharing this great work!

    I was searching for an embedded MySQL and found your great blog. I really need your help.. Do you have a distribution for win32 & Python 2.5?

  10. Scott Turnbull, on August 17th, 2009 at 21:06 Said:

    This was a real lifesaver. I have had the hardest time getting the library compiled on Windows for use with Python 2.6 and this worked fined. Thanks again.

  11. Matt, on August 19th, 2009 at 17:58 Said:

    Hey I noticed that I get a Warning when using the module:

    Warning (from warnings module):
    File “C:\Python26\lib\site-packages\MySQLdb\__init__.py”, line 34
    from sets import ImmutableSet
    DeprecationWarning: the sets module is deprecated

    Not a big deal, just a heads up for anyone on python 2.6. I was getting really frustrated with mysql-python until I found this! Great work.

  12. mg, on August 25th, 2009 at 21:45 Said:

    спасибо мужик :)

  13. André Lucas, on September 15th, 2009 at 22:16 Said:

    Thanks so much, this has really helped me out.

  14. Robert Krolik, on October 2nd, 2009 at 18:09 Said:

    Thanks a lot :) Great job

  15. David Marble, on October 2nd, 2009 at 20:58 Said:

    If you’re on Windows (I’m using Windows 7 64-bit) and get the error that python version 2.6 is not found in the registry (might just be a problem with ActiveState), just manually add the registry keys so this exists:

    HKLM\Software\Python\PythonCore\2.6\InstallPath

    Then change the value of (Default) under that key to “C:\python26″ or your own path\to\python2.6

    Installation of the above files should work then.

  16. Stig Mattsson, on October 10th, 2009 at 20:20 Said:

    Thank you, David, for your comments on the 64-bit issue, it has really been helpful.

  17. Thomas, on October 25th, 2009 at 20:25 Said:

    Hello,

    I’m trying to get Py 2.6 and Mysql running on a windows 7 (64-Bit) system.
    It works fine – thanx a lot!

    The only problem I experienced is the following:
    The installer stops with windows exception (I don’t know how to call it) if I don’t use the predefined path. (I tried the “german” path c:\programme\python26

    Any ideas?

    Thomas

  18. Dorrith Pennink, on November 4th, 2009 at 14:00 Said:

    I am running under vista 64, I’ve installed mysql but running my python file i get this errormessage:

    from MySQLdb import connect
    File “C:\Python26\lib\site-packages\MySQLdb\__init__.py”, line 19, in
    import _mysql
    ImportError: DLL load failed: %1 is geen geldige Win32-toepassing.

    Any suggestions how to avoid this? Thanks

  19. YiXia, on November 10th, 2009 at 04:47 Said:

    thanks a lot with tears
    you are so great!!

  20. Anthony Leotta, on November 27th, 2009 at 07:31 Said:

    Can you run MySQL-python-1.2.3c1.win32-py2.6.exe and MySQL-python-embedded-1.2.3c1.win32-py2.6.exe side by side?

    if so how?

    I tried and it didn’t seem to work.

  21. Frustrated Coder, on January 26th, 2010 at 05:31 Said:

    OMG I LOVE YOU. THANK YOU SO MUCH.

    I just wasted four hours of my life trying to get Visual C and mingw and distutils and Python to all play nicely on 64bit Vista. And then I spent all of thirty seconds clicking next and install in your application.

    Thanks again!

  22. Brian, on February 1st, 2010 at 03:52 Said:

    Thanks for providing these. Saved me much time with a Windows installation of a Django web site.

  23. ZOMGWHY, on February 2nd, 2010 at 22:49 Said:

    When i try using the “MySQL-python-1.2.2.win-amd64-py2.6.exe”, the installer freezes during setup and I don’t know why. I am using Python 2.6.4 64-bit on windows 7 64-bit.

    Thank you.

  24. Tupteq, on February 4th, 2010 at 16:40 Said:

    God bless you for this builds. There are good people on this world :)

  25. Hongwu, on February 5th, 2010 at 16:07 Said:

    Thanks for the build and the tip for windows 7 64 bit. I am also trying to run Django but keep getting “Error loading MySQLdb module: DLL load failed with error code 193″. I have tried to put the DLL file in the python directory and my project directory and the mysqlDB package directory but no lucky. Could you suggest me what does “program directory” exactly mean?
    Thanks in advance.

Leave a Reply