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

Last Updated on Sunday, 19 September 2010 04:58 Written by Ioannis Lalopoulos Sunday, 19 September 2010 02:27

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)



99 Comments

  1. jd   |  Tuesday, 17 January 2012 at 07:35

    Thanks a lot!!!

  2. Kalail   |  Friday, 20 January 2012 at 12:03

    You sir, are a god amongst men. Honestly, your package has solved the issue I’ve been hacking at all night.

  3. Kyle   |  Thursday, 26 January 2012 at 19:31

    Much thanks, had so many issues attempting to compile from source!

  4. Joe   |  Friday, 27 January 2012 at 01:59

    YES!!! u=awesome

  5. Stephen Clark Jr.   |  Friday, 27 January 2012 at 21:07

    Thanks, this is much appreciated.

  6. DIPPA   |  Sunday, 29 January 2012 at 00:15

    Thank a lot to give this 😉

  7. Cholavendhan   |  Sunday, 29 January 2012 at 08:57

    Thanks a lot.. I searched a lot.. Finally i got it with ease from u..

  8. Martin   |  Tuesday, 07 February 2012 at 00:19

    Just used this to install mysql-python into a virtual env by installing it into site-packages in the python install and then copying everything starting with ‘mysql’ into site-packages in my virtual env. Seemed to work – however, wondering if there’s a better way to do this? At the moment the installer picks up the python interpreter from the registry and so doesn’t support virtual envs, unless I’m missing something.
    Thanks, BTW – I was struggling to build from source (couldn’t get past gcc: error: /Zl: No such file or directory).

  9. J   |  Tuesday, 07 February 2012 at 04:29

    Awesome – took me a day to find this, but I did, and it works.

    Thank you for posting it.

    J

  10. Harsh   |  Thursday, 09 February 2012 at 00:58

    Thx a lot. You saved me much time.

  11. Mark Jones   |  Tuesday, 14 February 2012 at 22:36

    It would be TRULY awesome if you could key the virtual env you wanted it installed into. That way I wouldn’t have to resort to things like

    xcopy c:\python27\lib\site-packages\MySQLdb c:\Python\VirtualENV\lib\site-packages\MySQLdb /s/e
    And tell it that this is a directory (not a file)
    xcopy c:\python27\lib\site-packages\MySQL_python-1.2.3-py2.7.egg-info c:\Python\VirtualENV\lib\site-packages\ MySQL_python-1.2.3-py2.7.egg-info /s/e
    And tell it that this is a directory (not a file)

    copy c:\python27\lib\site-packages\_mysql*.* c:\Python\VirtualENV\lib\site-packages

    You may at some point have to deal with 1.2.3 being something else, and of course VirtualENV is the virtualENV you need the support in.

  12. sashan   |  Monday, 27 February 2012 at 16:11

    Absolutely awesome man, thanx a lot.
    Was struggling a lot with the package but your installer did the job just like that !

  13. Hari   |  Friday, 02 March 2012 at 09:43

    Thanks a lot! Just like others in the comments, spent quite a bit of time on building mysql-python for Windows in vain until I found this page!

  14. Asim   |  Monday, 05 March 2012 at 03:40

    You don’t understand how much I love you right now.

    Thanks!!!

  15. Ariel   |  Monday, 05 March 2012 at 08:34

    Really useful and simple binary. It just works.

  16. MCA   |  Wednesday, 07 March 2012 at 13:38

    Thanks, I shared the pain of the others, and now I share the joy 🙂

  17. Mike   |  Wednesday, 18 April 2012 at 20:09

    Thank you, thank you, thank you!

  18. greatghoul   |  Thursday, 03 May 2012 at 10:24

    I can’t tell more thanks, it spent me too much to find mysql-python for 64bit windows. thank you 🙂

  19. masa   |  Tuesday, 08 May 2012 at 12:21

    Thanks from japan!!!
    This was a great help to me!!!

  20. fzhang   |  Sunday, 13 May 2012 at 16:46

    Thank you so much. I’ve been unwilling to upgrade to python 2.7 because I can’t find this windows distribution. Now those days are gone. You are awesome. !!!

  21. Sid   |  Wednesday, 16 May 2012 at 20:51

    Thanks a ton…u got me going with my projects…

  22. wojtek   |  Tuesday, 22 May 2012 at 14:31

    Windows 7, 64-bit, Python 2.7.3 64-bit – all works great. Thank you.

  23. Installing Python Django MySQL with Apache on Windows | The Inspiration Within …   |  Monday, 28 May 2012 at 06:19

    […] MySQLdb Binaries Finally found them at http://www.codegood.com/archives/129 […]

  24. farshad   |  Tuesday, 05 June 2012 at 20:14

    thank you …..

  25. yuren   |  Tuesday, 19 June 2012 at 05:19

    i really need to say thank you to you!

  26. Nathan O'Brien   |  Thursday, 21 June 2012 at 21:55

    As so many have said before, thank you. After spending hours just reading what it was going to take to compile this myself, it was a God send to find your website, and that you had already done so. When we finish revamping our website, there will be a link to yours. Thank you again.

  27. Dikpal   |  Tuesday, 03 July 2012 at 20:34

    Thanks a lot. It helped me save a lot of time.

  28. Pedro   |  Tuesday, 03 July 2012 at 22:37

    Graciaaaaaasss!!!!! Thanks!!!!!

  29. Helica   |  Wednesday, 11 July 2012 at 13:10

    You, sir, are my hero! From this day the 19th of September shall be known as Ioannislalopoulosday! (At least in my agenda) Thank you so very much.

  30. Qiyuan Liu   |  Wednesday, 11 July 2012 at 23:44

    Thank you so much. Finally, I found it here!!!

  31. croc   |  Monday, 16 July 2012 at 03:13

    Thank you!
    Like most here, you have saved me heaps of stuffing around. It just worked!!!
    Awesome 🙂

  32. Lee   |  Saturday, 04 August 2012 at 07:13

    Halleluja!

  33. Albert   |  Friday, 17 August 2012 at 09:53

    Thank you very much,it solves my problem,you do great job

  34. vess   |  Thursday, 30 August 2012 at 14:44

    10x mate, this works

  35. Jorge   |  Tuesday, 07 May 2013 at 20:44

    Dear codegood.com Sirs
    May I ask you if you could kindly publish again such important downloads for mysql-python 1.2.3 and 1.2.4?.
    Currently trying to download just says “file does not exist.
    Your kind support is highly appreciated.
    Thanks in advance and Best regards!

  36. Ioannis Lalopoulos   |  Wednesday, 08 May 2013 at 01:17

    Thank you for your report. The mysql-python files are back in their place.

  37. http://sunhie.webnode.com   |  Wednesday, 08 May 2013 at 03:49

    Hi just wanted to give you a quick heads up and let you know a few of the images aren’t loading correctly. I’m not
    sure why but I think its a linking issue. I’ve tried it in two different web browsers and both show the same outcome.

  38. Ioannis Lalopoulos   |  Thursday, 09 May 2013 at 11:40

    Thank you for the heads up, images are fixed now.

  39. Adri   |  Sunday, 06 October 2013 at 21:03

    Great!!! works fine in Win7 64 Thanks!!

  40. onepeak   |  Wednesday, 23 October 2013 at 13:45

    Thank you very much. I wasted over 1 hour to try to solve the Django UnicodeDecodeError using 64bits Python and 32bits MySQLdb on Windows 8. After uninstalling the 32bits MySQLdb and installing your 64bits one, it finally works. You saved me.

  41. Lar   |  Friday, 01 November 2013 at 17:34

    Luckily I found this before I put much effort in trying to integrate them!
    Thanks.

  42. Guoqing   |  Friday, 03 January 2014 at 09:09

    Thanks a lot ! trac project should reference this link in their doc

  43. jlcheng   |  Saturday, 20 February 2016 at 12:25

    wonderful!

  44. Mla   |  Sunday, 23 October 2016 at 05:46

    Thank you so much!save me a lot of time!

  45. vish   |  Thursday, 19 January 2017 at 13:00

    Thanks a lot…

  46. Christoper   |  Monday, 30 January 2017 at 05:51

    Been trying for few days but not get any answer till I get your code.. Thanks a lot, God Bless!!

  47. Sarra   |  Wednesday, 01 March 2017 at 15:46

    You saved my life !! Thanks, may God bless you.

  48. J   |  Saturday, 08 April 2017 at 12:24

    Thanks. I am still needing it in 2017.

  49. Xs   |  Monday, 24 April 2017 at 07:00

    Thank you

Leave a Reply