红联Linux门户
Linux帮助

ubuntu14.04 python3.*连接mysql

发布时间:2016-10-13 10:54:48来源:linux网站作者:西北逍遥
先下载pymysql文件,http://webscripts.softpedia.com/script/Database-Tools/PyMySQL-71606.html
我下载的是:PyMySQL-0.7.4.zip
然后解压:$ unzip PyMySQL-0.7.4.zip
重命名:mv PyMySQL-0.7.4 py3mysql
登陆root,给该文件夹授权,否则安装不成功,# chmod -R 777 py3mysql
进入py3mysql  # cd py3mysql
运行setup.py进行安装:# python3 setup.py install
 
如果出现类似语句,说明安装成功。
Processing dependencies for PyMySQL==0.7.4
Finished processing dependencies for PyMySQL==0.7.4
 
接下来进行测试:
 
# python3 回车,进入python3
 
# 导入MySQL驱动: >>> import mysql.connector
 
# 注意把password设为你的root口令:
>>> conn = mysql.connector.connect(user='root', password='password', database='test')
>>> cursor = conn.cursor()
 
# 创建user表:
>>> cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')
 
# 插入一行记录,注意MySQL的占位符是%s:
>>> cursor.execute('insert into user (id, name) values (%s, %s)', ['1', 'Michael'])
>>> cursor.rowcount
1
 
# 提交事务:
>>> conn.commit() >>> cursor.close()
 
# 运行查询:
>>> cursor = conn.cursor()
>>> cursor.execute('select * from user where id = %s', ['1'])
>>> values = cursor.fetchall()
>>> values [('1', 'Michael')]
 
# 关闭Cursor和Connection:
>>> cursor.close()
True
>>> conn.close()
 
至此,ubuntu上的mysql数据库就能够支持python3.*
 
本文永久更新地址:http://www.linuxdiyf.com/linux/24984.html