codegood

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

Written by

Ioannis Lalopoulos

in

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)

Comments

109 responses to “MySQL-python 1.2.3 for Windows and Python 2.7, 32bit and 64bit versions”

  1. jd Avatar
    jd

    Thanks a lot!!!

    Reply
  2. Kalail Avatar
    Kalail

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

    Reply
  3. Kyle Avatar
    Kyle

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

    Reply
  4. Joe Avatar
    Joe

    YES!!! u=awesome

    Reply
  5. Stephen Clark Jr. Avatar
    Stephen Clark Jr.

    Thanks, this is much appreciated.

    Reply
  6. DIPPA Avatar
    DIPPA

    Thank a lot to give this 😉

    Reply
  7. Cholavendhan Avatar
    Cholavendhan

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

    Reply
  8. Martin Avatar
    Martin

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

    Reply
  9. J Avatar
    J

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

    Thank you for posting it.

    J

    Reply
  10. Harsh Avatar
    Harsh

    Thx a lot. You saved me much time.

    Reply
  11. Mark Jones Avatar
    Mark Jones

    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.

    Reply
  12. sashan Avatar
    sashan

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

    Reply
  13. Hari Avatar
    Hari

    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!

    Reply
  14. Asim Avatar
    Asim

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

    Thanks!!!

    Reply
  15. Ariel Avatar
    Ariel

    Really useful and simple binary. It just works.

    Reply
  16. MCA Avatar
    MCA

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

    Reply
  17. Mike Avatar
    Mike

    Thank you, thank you, thank you!

    Reply
  18. greatghoul Avatar
    greatghoul

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

    Reply
  19. masa Avatar
    masa

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

    Reply
  20. fzhang Avatar
    fzhang

    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. !!!

    Reply
  21. Sid Avatar
    Sid

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

    Reply
  22. wojtek Avatar
    wojtek

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

    Reply
  23. Installing Python Django MySQL with Apache on Windows | The Inspiration Within …

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

    Reply
  24. farshad Avatar
    farshad

    thank you …..

    Reply
  25. yuren Avatar
    yuren

    i really need to say thank you to you!

    Reply
  26. Nathan O'Brien Avatar
    Nathan O’Brien

    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.

    Reply
  27. Dikpal Avatar
    Dikpal

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

    Reply
  28. Pedro Avatar
    Pedro

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

    Reply
  29. Helica Avatar
    Helica

    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.

    Reply
  30. Qiyuan Liu Avatar
    Qiyuan Liu

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

    Reply
  31. croc Avatar
    croc

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

    Reply
  32. Lee Avatar
    Lee

    Halleluja!

    Reply
  33. Albert Avatar
    Albert

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

    Reply
  34. vess Avatar
    vess

    10x mate, this works

    Reply
  35. Jorge Avatar
    Jorge

    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!

    Reply
    1. Ioannis Lalopoulos Avatar
      Ioannis Lalopoulos

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

      Reply
  36. http://sunhie.webnode.com Avatar
    http://sunhie.webnode.com

    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.

    Reply
    1. Ioannis Lalopoulos Avatar
      Ioannis Lalopoulos

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

      Reply
  37. Adri Avatar
    Adri

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

    Reply
  38. onepeak Avatar
    onepeak

    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.

    Reply
  39. Lar Avatar
    Lar

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

    Reply
  40. Guoqing Avatar
    Guoqing

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

    Reply
  41. Instalando Python, Django, MySQL-python, Vim – Fernando Plaza

    […] http://www.codegood.com/archives/129 […]

    Reply
  42. jlcheng Avatar
    jlcheng

    wonderful!

    Reply
  43. Sam Avatar
    Sam

    Thank you very much

    Reply
  44. Mla Avatar
    Mla

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

    Reply
  45. vish Avatar
    vish

    Thanks a lot…

    Reply
  46. Christoper Avatar
    Christoper

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

    Reply
  47. Sarra Avatar
    Sarra

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

    Reply
  48. J Avatar
    J

    Thanks. I am still needing it in 2017.

    Reply
  49. Xs Avatar
    Xs

    Thank you

    Reply
  50. Peter Avatar
    Peter

    This works great. Thank you!!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

More posts