安装MySQL-python

1、使用yum安装

1.1检查MySQL-python

[root@gfsunny105 mysql_tools]# python

Python 2.4.3 (#1, Dec 10 2010, 17:24:32) 

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

Type "help", "copyright", "credits" or "license" for more information.

>>> import MySQLdb

Traceback (most recent call last):

  File "<stdin>", line 1, in ?

ImportError: No module named MySQLdb

>>> 

1.2使用yum安装

[root@gfsunny105 mysql_tools]# yum -y install MySQL-python

Loaded plugins: rhnplugin, security

This system is not registered with RHN.

RHN support will be disabled.

Setting up Install Process

Resolving Dependencies

--> Running transaction check

......

Install       3 Package(s)

Upgrade       0 Package(s)

Total download size: 5.5 M

Downloading Packages:

(1/3): MySQL-python-1.2.3-0.1.c1.el5.i386.rpm                                                                                                                                                                                          |  93 kB     00:00     

(2/3): perl-DBI-1.52-2.el5.i386.rpm                                                                                                                                                                                                    | 600 kB     00:01     

(3/3): mysql-5.0.95-5.el5_9.i386.rpm                                                                                                                                                                                                   | 4.9 MB     00:12     

......

Complete!

[root@gfsunny105 mysql_tools]# python 

Python 2.4.3 (#1, Dec 10 2010, 17:24:32) 

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

Type "help", "copyright", "credits" or "license" for more information.

>>> import MySQLdb

>>> 

    OK, MySQL-python安装完成。

2、下载安装

2.1下载

[root@gflinux4 shell]# wget http://sourceforge.net/projects/mysql-python/files/latest/download

[root@gflinux4 shell]# tar -zxvf MySQL-python-1.2.4b4.tar.gz

[root@gflinux4 shell]# cd MySQL-python-1.2.4b4

[root@gflinux4 MySQL-python-1.2.4b4]# ll

total 200

-rw-r--r-- 1 6296 games 16295 Oct  9  2012 distribute_setup.py

drwxr-xr-x 2 6296 games  4096 Dec 30 01:29 doc

-rw-r--r-- 1 6296 games 18092 Oct  9  2012 GPL-2.0

-rw-r--r-- 1 6296 games  5331 Oct  9  2012 HISTORY

-rw-r--r-- 1 6296 games  6636 Oct  9  2012 INSTALL

-rw-r--r-- 1 6296 games   317 Oct  9  2012 MANIFEST.in

-rw-r--r-- 1 6296 games  2064 Oct  9  2012 metadata.cfg

-rw-r--r-- 1 6296 games 80837 Oct  9  2012 _mysql.c

drwxr-xr-x 3 6296 games  4096 Dec 30 01:29 MySQLdb

-rw-r--r-- 1 6296 games  2352 Oct  9  2012 _mysql_exceptions.py

drwxr-xr-x 2 6296 games  4096 Dec 30 01:29 MySQL_python.egg-info

-rw-r--r-- 1 6296 games  1726 Oct  9  2012 PKG-INFO

-rw-r--r-- 1 6296 games  3203 Oct  9  2012 pymemcompat.h

-rw-r--r-- 1 6296 games  1266 Oct  4  2012 README.md

-rw-r--r-- 1 6296 games   410 Oct  9  2012 setup.cfg

-rw-r--r-- 1 6296 games  1088 Oct  9  2012 setup_common.py

-rw-r--r-- 1 6296 games  3233 Oct  9  2012 setup_posix.py

-rw-r--r-- 1 6296 games   593 Oct  9  2012 setup.py

-rw-r--r-- 1 6296 games  1334 Oct  9  2012 setup_windows.py

-rw-r--r-- 1 6296 games   665 Oct  9  2012 site.cfg

drwxr-xr-x 2 6296 games  4096 Oct  9  2012 tests

2.1查找mysql_config文件位置

[root@gflinux4 MySQL-python-1.2.4b4]# find / -name mysql_config

/usr/local/mysql/bin/mysql_config

2.2、编辑site.cfg文件

[root@gflinux4 MySQL-python-1.2.4b4]# vi site.cfg 

......

embedded = False

#threadsafe = True

threadsafe = False

static = False

# The path to mysql_config.

# Only use this if mysql_config is not on your PATH, or you have some weird

# setup that requires it.

#mysql_config = /usr/local/bin/mysql_config

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

# http://stackoverflow.com/questions/1972259/mysql-python-install-problem-using-virtualenv-windows-pip

# Windows connector libs for MySQL. You need a 32-bit connector for your 32-bit Python build.

connector = C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2

2.3安装

[root@gflinux4 MySQL-python-1.2.4b4]# python setup.py build

[root@gflinux4 MySQL-python-1.2.4b4]# python setup.py install

3、测试

[root@gfsunny105 mysql_tools]# python 

Python 2.4.3 (#1, Dec 10 2010, 17:24:32) 

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

Type "help", "copyright", "credits" or "license" for more information.

>>> import MySQLdb

>>>