mysql connector python linux_MySQL Connector/Python 安装、测试

安装Connector/Python：

# wget http://cdn.mysql.com/Downloads/Connector-Python/mysql-connector-python-1.0.11.zip

# 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()

By DBA_WaterBin

2013-07-25

Good Luck