If you want to connect MySQL to Python on your Mac running Leopard, here a few things you should know. First, download the MySQLdb API (I'm assuming you've already installed MySQL and it works) to connect python to MySQL. You'll find you won't be able to compile the API properly - fix that by reading Zen and the Art of Programming's fix (As a plus, it tells you how to install Django as well).
You can now test your installation by running a script from Kitebird's tutorial. Finally, if you want to learn how to use the API completely, read the Python Database API Specification v2.0. MySQLdb conforms to their API syntax, so you don't actually have to learn any MySQLdb-specific commands.