安装connector/python:
# wget
# unzip mysql-connector-python-1.0.11.zip
# cd mysql-connector-python-1.0.11
# python setup.py install
测试connector/python是否装上:
>>> from distutils.sysconfig import get_python_lib
>>> print get_python_lib()
/usr/local/lib/python2.7/site-packages
小实例:
[root@obe11g ~]# python
python 2.7.3 (default, jul 18 2013, 20:53:58)
[gcc 3.4.6 20060404 (red hat 3.4.6-3.1)] on linux2
type help, copyright, credits or license for more information.
>>> import mysql.connector
>>> cnx = mysql.connector.connect(user='waterbin',password='123',host='192.168.1.115',database='test')
>>> cur=cnx.cursor()
>>> cur.execute('select * from t')
>>> print cur.fetchall()
[(1,)]
>>> cnx.close()
mysql connector/python 的详细介绍:请点这里
mysql connector/python 的下载地址:请点这里
,
