Linux python链接mysql,linux上 python连接mysql 入门

linux下 python连接mysql 入门

1. 环境安装

yum -y install python.x86_64

yum -y install MySQL-python.x86_64

2. 测试demo

#!/usr/bin/env python

#-*- coding: utf-8 -*-

import os,sys

import MySQLdb

try:

db = MySQLdb.connect(host ='10.232.31.33', user='xxx', passwd='xxx', db ='xxx')

except MySQLdb.ERROR,e:

print "Error %d:%s"%(e.args[0],e.args[1])

exit(1)

cursor = db.cursor()

cursor.execute('select * from xxx_task')

result_set=cursor.fetchall()

print result_set

cursor.close()

db.close()

将例子保存为test.py

3. 执行

$chmod +x test.py

$python  test.py

如果看到有记录输出，说明连接成功了!