一、python2.x和python3.x在连接数据MySQL时有一定的差别:
1.python2.x连接MySQL需要安装MySQLdb
下载地址:http://sourceforge.net/projects/mysql-python/file/mysql-python/
同时MySQLdb还需要python-devel开发包,在CentOS下是python-devel,ubuntu下是python-dev,请大家看清楚。
2.python3.x连接MySQL需要pymysql
下载地址:http://webscripts.softpedia.com/script/Database-Tools/PyMySQL-71606.html
在这里我只演示CentOS下python2.x与MySQL的连接
二、
1、安装mysql
yum install mysql-server -y
yum install mysql -y
yum install mysql-devel -y
2、安装MySQLdb
$ tar xfz MySQL-python-1.2.1.tar.gz
$ cd MySQL-python-1.2.1
$ # edit site.cfg if necessary
$ python setup.py build
$ sudo python setup.py install # or su first
三、测试
fnngj@fnngj-H24X:~/pyse$ python
Python 2.7.4 (default, Sep 26 2013, 03:20:56)
[GCC 4.7.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb