python连mysql

一.python连mysql安装 MySQLdb

wget https://pypi.python.org/packages/d3/16/21cf5dc6974280197e42d57bf7d372380562ec69aef9bb796b5e2dbbed6e/setuptools-20.10.1.tar.gz#md5=cc3f063d05e3bff4d3fa07a5a1017c3b
tar zxvf setuptools-20.10.1.tar.gz
cd setuptools-20.10.1
python setup.py install

yum -y install python-devel.x86_64

wget https://pypi.python.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip#md5=654f75b302db6ed8dc5a898c625e030c
unzip MySQL-python-1.2.5.zip
cd MySQL-python-1.2.5
python setup.py install

二.使用mysqldb

import MySQLdb
import MySQLdb.cursors

try:
        db= MySQLdb.connect(host=myhost,port=myport,user=myuser,passwd=mypassword,db=mydb,connect_timeout=mytimeout,cursorclass=MySQLdb.cursors.DictCursor)
        cursor=db.cursor()
        cursor.execute(query)
        db.commit()
        result=cursor.fetchall()
        return 0
    except MySQLdb.Error as e:
        print e
    finally:
        cursor.close()        

        db.close()