Installing the python MySQLdb module on snow leopard

Ive been spending the last 2 nights trying to get the MySQLdb module installed on snow leopard, but i finally got it below are the steps that i took in order to get module installed and working.


1. Install mysql server from the macports tree using the following command:
sudo port install mysql5-server

2. Download a copy of MySQL-python from sourceforge.net at the time of this writing they are up to MySQL-python-1.2.3c1.tar.gz


3. unpack the MySQL-python-1.2.3c1.tar.gz package using the following command:
tar -xzvf MySQL-python-1.2.3c1.tar.gz


4. cd into the MySQL-python-1.2.3c1 directory


5. In the MySQL-python-1.2.3c1 directory there is a file named site.cfg, open that file with you favorite editor (mine being vi :) ) and locate the following line:


# The path to mysql_config.
# Only use this if mysql_config is not on your PATH, or you have some weird
# setup that requires it.
mysql_config = /usr/local/bin/mysql_config


if you are unsure where you mysql_config file is located, just do a search on your system using the find command.

6. Once the site.cfg has been edited now you are all set and ready to install the module with the following command:

sudo python setup.py install


7. enjoy :)