I am just re-inventing the wheel here. I had this article on this site but the previous hosting was expired and my database file was corrupted, so I had to do this again. And I also know at least one person will be looking for that information soon, so I am contributing to the community again in some simple steps,
- Download the latest version of MySQLdb
- Locate mysql_config
- Open site.cfg and update mysql_config path
sudo python setup.py build
sudo python setup.py install
Now if you import MySQLdb in your python CLI it should just work fine. Let me know if you still have some problem. I will try to reshape my reinvented wheel.