Centos环境下MySQL-python安装过程2012-06-05 11:43:43

Centos环境下MySQL-python安装过程2012-06-05 11:43:43 Tuesday, July 22, 2014 5:06 PM Centos环境下MySQL-python安装过程 2012-06-05 11:43:43 标签： python

mysql

centos 原创作品，允许转载，转载时请务必以超链接形式标明文章 原始出处 、作者信息和本声明。否则将追究法律责任。 http://lihuipeng.blog.51cto.com/3064864/887967 1.

下载

MySQL-python-1.2.3.tar.gz

地址

https://sourceforge.net/projects/mysql-python/ 2.

安装

MySQl-python

tar xvf MySQL-python-1.2.3.tar.gz

cd MySQL-python-1.2.3

vi site.cfg

把

mysql_config = /usr/local/mysql/bin/mysql_config

这一行前的 # 去掉，并且把 mysql_config 的路径设置正确。

python setup.py build 报错如下： 解决方法： yum install mysql-devel* yum install python-devel

再运行python setup.py build报错如下：

[root@localhost MySQL-python-1.2.3]# python setup.py install

Traceback (most recent call last):

File “setup.py”, line 5, in ?

from setuptools import setup, Extension

ImportError: No module named setuptools 解决方法： wget

http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c11.tar.gz

tar zxvf setuptools-0.6c11.tar.gz

cd setuptools-0.6c11

python setup.py build

python setup.py install 继续安装： python setup.py build

python setup.py install 运行测试： [root@localhost MySQL-python-1.2.3]# python

Python 2.4.3 (#1, Sep 3 2009, 15:37:37)

[GCC 4.1.2 20080704 (Red Hat 4.1.2-46)] on linux2

Type “help”, “copyright”, “credits” or “license” for more information.

import MySQLdb

/usr/lib64/python2.4/site-packages/MySQL_python-1.2.3-py2.4-linux-x86_64.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /usr/lib64/python2.4/site-packages/MySQL_python-1.2.3-py2.4-linux-x86_64.egg/_mysql.pyc, but /opt/python/MySQL-python-1.2.3 is being added to sys.path

报出一大堆警告信息，解决办法：删除 MySQL-python 源目录，再测试一下： [root@localhost python]# python

Python 2.4.3 (#1, Sep 3 2009, 15:37:37)

[GCC 4.1.2 20080704 (Red Hat 4.1.2-46)] on linux2

Type “help”, “copyright”, “credits” or “license” for more information.

import MySQLdb

Mysql模块终于正常了！ 注:python2链接数据库试用Mysql模块,3版本后使用mysql-connector-python,安装方法一样,都是三步: 1.解压 2.python3.4 setup.py build 3.python3.4 setup.py install

一键脚本 #!/bin/bash

echo “mysql_config = $cfpath” » site.cfg

yum install -y mysql-devel* python-devel

python setup.py build & & python setup.py install

if python -c “import MySQLdb” &

/dev ull;then

exit 0

else

exit 1

fi ##############END

已使用 Microsoft OneNote 2016 创建。