Connect to mySQL from Python

I would like to connect to a mySQL database running on dreamhost from a Python script also running on dreamhost. I setup a database and can access it via puTTY. I have setup a cgi-bin directory where I can execute .py files and get results back via html. I wonder if anyone has any hints or examples of how to tunnel from my Python world to my mySQL world?