test_mysql.py

import MySQLdb

if __name__ == "__main__":
  db = MySQLdb.Connect(host="localhost", user="user",passwd="",db="mysqldbname")
  cursor = db.cursor()
  cursor.execute("SHOW ENGINES")

  for row in cursor.fetchall():
    print row

  cursor.close()
  db.close()