使用 pip 安装 出现错误
到 https://dev.mysql.com/downloads/connector/python/ 手动下载
下载完成后:
unzip mysql-connector-python-2.1.3.zip
cd mysql-connector-python-2.1.3
进入到文件目录后安装:
sudo python setup.py install
进入到安装,10秒左右完成,这样就可以在python程序里正常使用”import mysql.connector as mysql”导入MySQL的connector模块了,使用也很简单。
下面的代码是一个简单查询一个数据表里数据的实例:
#coding=utf-8
#!/usr/bin/python
import mysql.connector;
try:
conn = mysql.connector.connect(host=’172.0.0.1′, port=’3306′, user=’username’, password=”123456″, database=”testdev”, use_unicode=True);
cursor = conn.cursor();
cursor.execute(‘select * from t_user t where t.id = %s’, ‘1’);
# 取回的是列表,列表中包含元组
list = cursor.fetchall();
print list;
for record in list:
print “Record %d is %s!” % (record[0], record[1]);
except mysql.connector.Error as e:
print (‘Error : {}’.format(e));
finally:
cursor.close;
conn.close;
print ‘Connection closed in finally’;