python 学习入门（4）—— 连接 mysql
下载 mysql for python，最新版 mysql-python-1.2.4b4.tar.gz
1） 提前安装：mysql_config 环境
否则后面 python setup.py build 会提示找不到 “environmenterror: mysql_config not found”，安装命令如下：
sudo apt-get install libmysqlclient-dev
2） 然后，再安装mysqldb
$ tar zxvf mysql-python-1.2.2.tar.gz
$ cd mysql-python-1.2.2
$ sudo python setup.py build
$ sudo python setup.py install
3） 验证成功安装
homer@ubuntu:~/mycode/python$ python
python 2.7.3 (default, aug 1 2012, 05:14:39)
[gcc 4.6.3] on linux2
type help, copyright, credits or license for more information.
>>> import mysqldb
>>>
import mysqldb 没有出错，说明安装成功！
python 连接mysql示例：
##################### it-homer# 2013-05-10####################import mysqldbdb = mysqldb.connect(host=localhost, user=root, passwd=abcd1234, db=testdb)cursor = db.cursor()cursor.execute(select * from gametestdb limit 10)result = cursor.fetchall()for row in result: #print row #print row[0], row[1], row[2] #print '%s, %s, %s' % (row[0], row[1], row[2]) print ', '.join([str(row[0]), str(row[1]), str(row[2])])cursor.close()'''import sysimport mysqldbreload(sys)sys.setdefaultencoding('utf-8')db = mysqldb.connect(user='root', passwd='abcd1234', charset='utf8')cur = db.cursor()cur.execute('use testdb')cur.execute('select * from gametestdb limit 10')f = file(/home/homer/tmp_mysql.txt, 'w')for row in cur.fetchall(): f.write(str(row)) f.write(\n)f.close()cur.close()'''
##################### it-homer# 2013-05-10####################import mysqldb# local mysql# db = mysqldb.connect(host=localhost, user=root, passwd=abcd1234, db=testdb)# aws rds mysqldb = mysqldb.connect(host=ithomer.aliyun.com, user=ithomer, passwd=abcd1234, db=dman)cursor = db.cursor()cursor.execute(select * from score limit 10)result = cursor.fetchall()for row in result: #print row #print row[0], row[1], row[2] #print '%s, %s, %s' % (row[0], row[1], row[2]) print ', '.join([str(row[0]), str(row[1]), str(row[2])])cursor.close()'''import sysimport mysqldbreload(sys)sys.setdefaultencoding('utf-8')db = mysqldb.connect(user='root', passwd='abcd1234', charset='utf8')cur = db.cursor()cur.execute('use testdb')cur.execute('select * from gametestdb limit 10')f = file(/home/homer/tmp_mysql.txt, 'w')for row in cur.fetchall(): f.write(str(row)) f.write(\n)f.close()cur.close()
参考推荐：
python 連接 mysql
mysqldb user's guide
python 字符串操作
mysql_config not found（stackover flow）
python 创建mysql数据库