Python2.7 -- 连接MYSQL小程序

# coding:utf-8
import mysql.connector

conn = mysql.connector.connect(host='192.168.15.32', port='3306', user='devuser', password='1001hk', database='dx20', \
                               use_unicode=True)
cursor = conn.cursor()
cursor.execute('select id,phone,real_name from t_user order by id desc limit 10')
values = cursor.fetchall()

for row in values:
    id = row[0]
    phone = row[1]
    realName = row[2]
    if (realName is None):
        print (id, phone, realName)
    else:
        print 'USERID:%s, PHONE:%s , realName: %s' % (id, phone, realName.encode('utf-8').decode('utf-8'))

cursor.close()
conn.close()

• 其中注意17行，中文转码的用法。否则输出的16位的UNICODE编码
• 另外连接mysql前，我们需要安装python第三方模块，执行命令pip instal mysql-connector-python
• 模块的API官方文档：https://dev.mysql.com/doc/connector-python/en/connector-python-example-connecting.html