linux安装mysqldb是被,Linux上安装配置mysqldb和sqlalchemy

我的机器是redhat 5.7

1.安装mysql-client和mysql-share

我对应的版本是：MySQL-client-5.6.16-1.rhel5.x86_64.rpm和 MySQL-shared-5.6.16-1.rhel5.x86_64.rpm

sudo rpm -ivf MySQL-client-5.6.16-1.rhel5.x86_64.rpm

sudo rpm -ivf MySQL-shared-5.6.16-1.rhel5.x86_64.rpm

2.安装MySQL-devel

我对应的版本是MySQL-devel-5.6.16-1.rhel5.x86_64.rpm

3.下载安装setuptools

https://pypi.python.org/pypi/setuptools中下载ez_setup.py文件，pypi网站下载很慢，建议把setuptools-3.2.zip下载好，和ez_setup.py文件在同一级目录下

http://pypi.douban.com/packages/source/s/setuptools/setuptools-3.2.zip(这里使用了pypi在豆瓣网的镜像，否则下载很慢)

4.下载MySQL-python-1.2.3.tar.gz，地址http://nchc.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz

tar -xzvf MySQL-python-1.2.3.tar.gz

cd MySQL-python-1.2.3

sudo python setup.py build

running build

running build_py

copying MySQLdb/release.py -> build/lib.linux-x86_64-2.7/MySQLdb

running build_ext

building '_mysql' extension

gcc -pthread -fno-strict-aliasing -g -O2 -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -fPIC -Dversion_info=(1,2,3,'final',0) -D__version__=1.2.3 -I/usr/include/mysql -I/usr/local/python27/include/python2.7 -c _mysql.c -o build/temp.linux-x86_64-2.7/_mysql.o -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -fPIC -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1

In file included from _mysql.c:36:

/usr/include/mysql/my_config.h:442:1: warning: "HAVE_WCSCOLL" redefined

In file included from /usr/local/python27/include/python2.7/Python.h:8,

from pymemcompat.h:10,

from _mysql.c:29:

/usr/local/python27/include/python2.7/pyconfig.h:890:1: warning: this is the location of the previous definition

gcc -pthread -shared build/temp.linux-x86_64-2.7/_mysql.o -L/usr/lib64 -lmysqlclient_r -lpthread -lm -lrt -ldl -o build/lib.linux-x86_64-2.7/_mysql.so

sudo python setup.py install

running install

running bdist_egg

running egg_info

writing MySQL_python.egg-info/PKG-INFO

writing top-level names to MySQL_python.egg-info/top_level.txt

writing dependency_links to MySQL_python.egg-info/dependency_links.txt

reading manifest file 'MySQL_python.egg-info/SOURCES.txt'

reading manifest template 'MANIFEST.in'

warning: no files found matching 'MANIFEST'

warning: no files found matching 'ChangeLog'

warning: no files found matching 'GPL'

writing manifest file 'MySQL_python.egg-info/SOURCES.txt'

installing library code to build/bdist.linux-x86_64/egg

running install_lib

running build_py

copying MySQLdb/release.py -> build/lib.linux-x86_64-2.7/MySQLdb

running build_ext

creating build/bdist.linux-x86_64

creating build/bdist.linux-x86_64/egg

creating build/bdist.linux-x86_64/egg/MySQLdb

copying build/lib.linux-x86_64-2.7/MySQLdb/connections.py -> build/bdist.linux-x86_64/egg/MySQLdb

copying build/lib.linux-x86_64-2.7/MySQLdb/cursors.py -> build/bdist.linux-x86_64/egg/MySQLdb

copying build/lib.linux-x86_64-2.7/MySQLdb/release.py -> build/bdist.linux-x86_64/egg/MySQLdb

creating build/bdist.linux-x86_64/egg/MySQLdb/constants

copying build/lib.linux-x86_64-2.7/MySQLdb/constants/FLAG.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants

copying build/lib.linux-x86_64-2.7/MySQLdb/constants/FIELD_TYPE.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants

copying build/lib.linux-x86_64-2.7/MySQLdb/constants/CR.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants

copying build/lib.linux-x86_64-2.7/MySQLdb/constants/REFRESH.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants

copying build/lib.linux-x86_64-2.7/MySQLdb/constants/CLIENT.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants

copying build/lib.linux-x86_64-2.7/MySQLdb/constants/ER.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants

copying build/lib.linux-x86_64-2.7/MySQLdb/constants/__init__.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants

copying build/lib.linux-x86_64-2.7/MySQLdb/times.py -> build/bdist.linux-x86_64/egg/MySQLdb

copying build/lib.linux-x86_64-2.7/MySQLdb/converters.py -> build/bdist.linux-x86_64/egg/MySQLdb

copying build/lib.linux-x86_64-2.7/MySQLdb/__init__.py -> build/bdist.linux-x86_64/egg/MySQLdb

copying build/lib.linux-x86_64-2.7/_mysql.so -> build/bdist.linux-x86_64/egg

copying build/lib.linux-x86_64-2.7/_mysql_exceptions.py -> build/bdist.linux-x86_64/egg

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/connections.py to connections.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/cursors.py to cursors.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/release.py to release.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/FLAG.py to FLAG.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/FIELD_TYPE.py to FIELD_TYPE.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/CR.py to CR.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/REFRESH.py to REFRESH.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/CLIENT.py to CLIENT.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/ER.py to ER.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/__init__.py to __init__.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/times.py to times.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/converters.py to converters.pyc

byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/__init__.py to __init__.pyc

byte-compiling build/bdist.linux-x86_64/egg/_mysql_exceptions.py to _mysql_exceptions.pyc

creating stub loader for _mysql.so

byte-compiling build/bdist.linux-x86_64/egg/_mysql.py to _mysql.pyc

creating build/bdist.linux-x86_64/egg/EGG-INFO

copying MySQL_python.egg-info/PKG-INFO -> build/bdist.linux-x86_64/egg/EGG-INFO

copying MySQL_python.egg-info/SOURCES.txt -> build/bdist.linux-x86_64/egg/EGG-INFO

copying MySQL_python.egg-info/dependency_links.txt -> build/bdist.linux-x86_64/egg/EGG-INFO

copying MySQL_python.egg-info/top_level.txt -> build/bdist.linux-x86_64/egg/EGG-INFO

writing build/bdist.linux-x86_64/egg/EGG-INFO/native_libs.txt

zip_safe flag not set; analyzing archive contents...

creating dist

creating 'dist/MySQL_python-1.2.3-py2.7-linux-x86_64.egg' and adding 'build/bdist.linux-x86_64/egg' to it

removing 'build/bdist.linux-x86_64/egg' (and everything under it)

Processing MySQL_python-1.2.3-py2.7-linux-x86_64.egg

Copying MySQL_python-1.2.3-py2.7-linux-x86_64.egg to /usr/local/python27/lib/python2.7/site-packages

Adding MySQL-python 1.2.3 to easy-install.pth file

Installed /usr/local/python27/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-x86_64.egg

Processing dependencies for MySQL-python==1.2.3

Finished processing dependencies for MySQL-python==1.2.3

5.下载安装sqlalchemy

http://pypi.douban.com/packages/source/S/SQLAlchemy/SQLAlchemy-0.9.3.tar.gz

tar -xzvf SQLAlchemy-0.9.3.tar.gz

cd SQLAlchemy-0.9.3

sudo python setup.py install

在安装mysql-python过程中曾经出现

/usr/local/python27/include/python2.7/pyconfig.h:890:1: warning: this is the location of the previous definition

gcc -pthread -shared build/temp.linux-x86_64-2.7/_mysql.o -L/usr/lib64 -lmysqlclient_r -lpthread -lm -lrt -ldl -o build/lib.linux-x86_64-2.7/_mysql.so

/usr/bin/ld: cannot find -lmysqlclient_r

collect2: ld returned 1 exit status

error: command 'gcc' failed with exit status 1

折腾了很久，后来把MySQL-shared-5.6.16-1.rhel5.x86_64.rpm 安装好，什么都解决了