python 连接mysql

#encoding=utf-8
# __author__ = 'Jason Han'


import MySQLdb



try:
    conn = MySQLdb.connect(host = 'localhost',user = 'root', passwd = '', port = 3306)
    cur = conn.cursor()
    cur.execute('select * from test.test1') 
    rows = cur.fetchall();
    print rows
    cur.close()
    conn.close()
except MySQLdb.Error,e:
    print"Mysql Error %d: %s" %(e.args[0],e.args[1])

具体连接到某个数据库的某个表用 select * from test.test1.