1，下载源码包

wget 'http://downloads.sourceforge.net/project/mysql-python/mysql-python-test/1.2.3c1/MySQL-python-1.2.3c1.tar.gz?use_mirror=nchc'

2，解压安装 （注意README，养成查看README的习惯）

tar -zxvf MySQL-python-1.2.3c1.tar.gz

cd MySQL-python-1.2.3c1

more setup.py

python 第三方模块MySQLdb安装_第三方


python setup.py install


3,验证是否安装成功。

a，查看 /usr/lib64/python2.6/site-packages下是否有内容，如有内容则ok

b，从python shell中import MySQLdb，如不报错则ok


常见使用：

Python代码
  1. # -*- coding: utf-8 -*- 
  2. #mysqldb 
  3. import time, MySQLdb 
  4. #连接 
  5. conn=MySQLdb.connect(host="localhost",user="root",passwd="",db="test",charset="utf8") 
  6. cursor = conn.cursor() 
  7. #写入 
  8. sql = "insert into user(name,created) values(%s,%s)"
  9. param = ("aaa",int(time.time())) 
  10. n = cursor.execute(sql,param) 
  11. print n 
  12. #更新 
  13. sql = "update user set name=%s where id=3"
  14. param = ("bbb") 
  15. n = cursor.execute(sql,param) 
  16. print n 
  17. #查询 
  18. n = cursor.execute("select * from user") 
  19. for row in cursor.fetchall(): 
  20. for r in row: 
  21. print r 
  22. #删除 
  23. sql = "delete from user where name=%s"
  24. param =("aaa") 
  25. n = cursor.execute(sql,param) 
  26. print n 
  27. cursor.close() 
  28. #关闭 
  29. conn.close()