使用python连接数据库

import MySQLdb

conn = MySQLdb.connect(host="localhost", \

                       user="root", \

                       passwd="root", \

                       db="TestDB")

cursor = conn.cursor()

cursor.execute("select * from Users")

res = cursor.fetchall()

print res

cursor.close()

conn.close()