Sylvain Zimmer

I’m testing the new wordpress iPhone app, and it rocks! The UI is neat while still exposing a lot of features so congrats to the wp devs!

Like many others, I struggled for a good hour to install the recommended MySQL module for Python, which is MySQLdb. So I’m sharing here the solution I found

The latest MAMP (1.7.1) uses MySQL 5.0.41, and MacOS X Leopard (10.5) uses Python 2.5.1 . As I couldn’t find a prebuilt MySQLdb binary for those versions, well, I had to compile my own.

So let’s go for it :

• Download an old copy of mysql 5.0.41
• Download the latest MySQLdb


$ tar zxvf mysql-5.0.41.tar.gz
$ cd mysql-5.0.41
$ ./configure && make
$ sudo make install
$ cd ..

(now MySQL is installed in /usr/local/)

$ tar zxvf MySQLdb...
$ cd MySQLdb...

• In the MySQLdb folder, edit the file _mysql.c
  • Delete the following lines :
    

    #ifndef uint
    #define uint unsigned int
    #endif

  • Replace 2 occurences of “uint” by “unsigned int”
• Then edit the site.cfg file, and set the mysql_config variable to “/usr/local/bin/mysql_config”


(Still in the MySQLdb folder)

$ python setup.py clean
$ python setup.py build
$ sudo python setup.py install
$ sudo rm /tmp/mysql.sock
$ sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock


And that’s it! You should now be able to “import MySQLdb” in python. Good luck!

jscrypt: the best (well… at least the geekiest) way to chat with your buddies about your top-secret projects you don’t want Gmail or Facebook to know about