Step 0:
Before I start, I assumed that you have MySQL and Python installed on the mac.
python ez_setup.py
Step 1:
Download the latest MySQL for Python adapter from SourceForge.
Step 2:
Extract your downloaded package by typing
$ tar xzvf MySQL-python-1.2.2.tar.gz
Step 3:
Inside the folder, clean the package by typing
$ sudo python setup.py clean
Step 4:
In the same folder, edit _mysql.c using your favourite text-editor
4a. Remove the following lines (37-39):
#ifndef uint
#define uint unsigned int
#endif
4b. Change the following:
uint port = MYSQL_PORT;
uint client_flag = 0;
to
unsigned int port = MYSQL_PORT;
unsigned int client_flag = 0;
Step 5:
Create a symbolic link under lib to point to a sub-directory called mysql. This is where it looks for during compilation.
$ sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql
Step 6:
Edit the setup_posix.py and change the following
mysql_config.path = "mysql_config"
to
mysql_config.path = "/usr/local/mysql/bin/mysql_config"
Step 7:
In the same directory, rebuild your package (ignore the warnings that comes with it)
$ sudo python setup.py build
Step 8:
Install the package and you are done.
$ sudo python setup.py install
Step 9:
Test if it's working. It works if you can import MySQLdb.
$ python
>>> import MySQLdb