python访问mysql

import MySQLdb

#host,user,password,dbname
cxn = MySQLdb.connect('10.0.32.83','devuser','devuser1234','supplier_site')
cur = cxn.cursor()
cur.execute('select * from findex limit 0,100')
for rs in cur.fetchall():
print rs

安装MySQLdb模块，参看：

在linux下安装MySQLdb