import MySQLdb

cn = MySQLdb.connect(db="test", host="127.0.0.1", port=3306, user="root", passwd="P@ssW0rd")
cur = cn.cursor()
cur.execute("SELECT 'Hello, DB API World!' AS Message")
rows = cur.fetchall()

for row in rows:
    print "Message"
    print "-------------------"
    print row[0]

cur.close()
cn.close()