python安装

1、python安装：官方下载Python-2.7.2.tgz

tar -zxvf Python-2.7.2.tgz
cd Python-2.7.2
./configure --prefix=/home/work/local/python-2.7
make && make install
 

2、安装mysql：官方下载 mysql-5.1.30.tar.gz

//下载解压
tar zxvf mysql-5.1.30.tar.gz
cd mysql-5.1.30
//配置
./configure \
--prefix=/home/work/local/mysql \
--with-charset=utf8 \
--enable-local-infile \
--with-unix-socket-path=/home/work/local/mysql/mysql.sock \
--with-tcp-port=8899 \
--enable-thread-safe-client \
--with-client-ldflags=-all-static \
--with-mysqld-ldflags=-all-static \
--with-plugins=partition,blackhole,heap,innobase,myisam,ndbcluster
//编译安装
make && make install
//配置服务
cd /home/work/local/mysql
./bin/mysql_install_db cp ./share/mysql/my-small.cnf ./my.cnf
//启动服务
./bin/mysqld_safe

3、安装setuptools

wget http://peak.telecommunity.com/dist/ez_setup.py
wget http://pypi.python.org/packages/2.7/s/setuptools/setuptools-0.6c11-py2.7.egg
//修改ez_setup.py中 egg = download_setuptools(version, delay=0)为setuptools-0.6c11-py2.7.egg路径
//在当前python路径中建立
python ez_setup.py

4、安装mysql扩展：官方下载MySQL-python-1.2.3.tar.gz

//修改site.cfg
/*
embedded = False
threadsafe = False
static = False
mysql_config = /home/work/local/mysql/bin/mysql_config
*/
python setup.py build
python setup.py install
//检查 python import MySQLdb

问题一： 未找到mysql_config
解决方法：在site.cfg中修改mysql_config配置

问题二：import MySQLdb失败

>>> import MySQLdb

ImportError: libmysqlclient.so.14: cannot open shared object file: No such file or directory

解决方法：在环境变量中指定libmysqlclient.so的位置，
如： export LD_LIBRARY_PATH=/home/work/local/mysql/lib/mysql

或建立libmysqlclient.so的软链接

>>> import MySQLdb

/usr/local/lib/python2.5/site-packages/MySQL_python-1.2.2-py2.5-linux-x86_64.egg/_mysql.py:3:UserWarning: Module _mysql was already imported from /usr/local/lib/python2.5/site-packages/MySQL_python-1.2.2-py2.5-linux-x86_64.egg/_mysql.pyc, but /home/passport/MySQL-python-1.2.2 is being added to sys.path
import sys, pkg_resources, imp

解决方法：换一个目录运行python交互shell

问题三：找不到libmysqlclient_r.so

解决方法：site.cfg中不需要的库全部设置为False:

threadsafe = False

4、安装xlrd/xlwt/xlutils

下载

xlrd-0.7.2.tar.gz

xlwt-0.7.4.tar.gz

xlutils-1.6.0.tar.gz

解压执行：

python setup.pyt install