import sys  
reload(sys)  
sys.setdefaultencoding('utf8') 
import mysql.connector


conn = mysql.connector.connect(
    user = 'root',
    password = 'LeCunKe20170215',
    host = '123.56.79.57',
    database = 'xt-dc'
)
cur = conn.cursor()
 

query = ("SELECT id,name FROM xt_seller")
 

cur.execute(query)
 
for (id, name) in cur:
    print("{}, {}".format(id, name))
 
cur.close()
conn.close()