Another installment in my OS X Python education: got Andy Dustman's MySQLdb module for Python working with the help of this post. You need to edit the setup.py script to help it find the right MySQL bits. Assuming you are using the binary version from mysql.com, it boils down to this:

include_dirs = ['/usr/local/mysql/include']
library_dirs = ['/usr/local/mysql/lib']