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 :
$ 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 :
#define uint unsigned int
- 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!