Connect to a MySQL using Python

Question

How do I connect to a MySQL database using a python program?

Answer 1

Very similar to mysqldb but better than mysqldb

import oursql

db_connection = oursql.connect(host='127.0.0.1',user='foo',passwd='foobar',db='db_name')
cur=db_connection.cursor()
cur.execute("SELECT * FROM `tbl_name`")
for row in cur.fetchall():
    print row[0]

The tutorial in the documentation is pretty decent.