MySQL-Python安装问题小记
安装完mysql-python后import加载模块提示以下错误,
ImportError:libmysqlclient_r.so.16:cannotopensharedobjectfile:Nosuchfileordirectory
于是google之,总结一下解决方法:
(1)在mysql-ython的安装目录下找到site.cfg,将
#mysql_config=XXXXXXXXXXXXXXXX
注释符号去掉,并填上mysql_config的地址
(2)将mysql/lib下所有关于libmysqlclient的so文件软链接到/usr/lib下。
ln-s/usr/local/mysql/lib/mysql/libmysqlclient*/usr/lib ldconfig
这样在加载
import_mysql
的时候就不会出错了
ubuntu安装mysql-python遇到的问题
版本是python2.6
使用easy_install安装MySQL-python
easy_install"MySQL-python==1.2.3"
提示:error:Setupscriptexitedwitherror:command'gcc'failedwithexitstatus1
需要安装python-devel
sudoapt-getinstallpython-dev
#apt-getinstallpython-devel
再使用easy_install安装就可以
如果使用pythonsetup.py安装,提示mysql_config找不到
EnvironmentError:mysql_confignotfound
需要安装下面2个开发包,需要注意的是apt-get里面是没有的,我使用新立德软件包管理器安装
libmysqld-dev
libmysqlclient-dev
安装完成以后需要修改MySQL-python-1.2.3文件夹下面的setup_posix.py中的第26行,
mysql_config.path="mysql_config"改为mysql_config的路径
whereismysql_config查找路径
mysql_config.path="/usr/bin/mysql_config"
再使用
pythonsetup.pybuild
pythonsetup.pyinstall
就可以
ubunturoot权限
sudo-i
安装MySQL-python问题解决
今天在centos安装MySQL-python,结果报错,报错信息如下:
Runningcommand/home/yunpeng.jiangyp/sys/python/bin/python-c"importsetuptools;__file__='/home/admin/jyp/build/MySQL-python/setup.py';exec(compile(open(__file__).read().replace('\r\n','\n'),__file__,'exec'))"install--single-version-externally-managed--record/tmp/pip-MH5Aya-record/install-record.txt runninginstall runningbuild runningbuild_py copyingMySQLdb/release.py->build/lib.linux-x86_64-2.7/MySQLdb runningbuild_ext building'_mysql'extension gcc-pthread-fno-strict-aliasing-g-O2-DNDEBUG-g-fwrapv-O3-Wall-Wstrict-prototypes-fPIC-Dversion_info=(1,2,5,'final',1)-D__version__=1.2.5-I/usr/include/mysql-I/home/yunpeng.jiangyp/sys/python/include/python2.7-c_mysql.c-obuild/temp.linux-x86_64-2.7/_mysql.o-g-pipe-Wp,-D_FORTIFY_SOURCE=2-fexceptions-fstack-protector--param=ssp-buffer-size=4-m64-D_GNU_SOURCE-D_FILE_OFFSET_BITS=64-D_LARGEFILE_SOURCE-fno-strict-aliasing-fwrapv _mysql.c:44:23:error:my_config.h:Nosuchfileordirectory _mysql.c:46:19:error:mysql.h:Nosuchfileordirectory _mysql.c:47:26:error:mysqld_error.h:Nosuchfileordirectory _mysql.c:48:20:error:errmsg.h:Nosuchfileordirectory _mysql.c:88:error:expectedspecifier-qualifier-listbefore‘MYSQL' _mysql.c:102:error:expectedspecifier-qualifier-listbefore‘MYSQL_RES'
google找到答案(http://stackoverflow.com/questions/13044201/install-mysql-python-return-error-in-centos),需要先安装mysql-devel.x86_64,通过
sudoyuminstallmysql-devel.x86_64
再次安装成功
[yunpeng.jiangyp@v010105~]$pipinstallMySQL-python Downloading/unpackingMySQL-python Runningsetup.pyegg_infoforpackageMySQL-python Installingcollectedpackages:MySQL-python Runningsetup.pyinstallforMySQL-python building'_mysql'extension gcc-pthread-fno-strict-aliasing-g-O2-DNDEBUG-g-fwrapv-O3-Wall-Wstrict-prototypes-fPIC-Dversion_info=(1,2,5,'final',1)-D__version__=1.2.5-I/usr/include/mysql-I/home/yunpeng.jiangyp/sys/python/include/python2.7-c_mysql.c-obuild/temp.linux-x86_64-2.7/_mysql.o-g-pipe-Wp,-D_FORTIFY_SOURCE=2-fexceptions-fstack-protector--param=ssp-buffer-size=4-m64-D_GNU_SOURCE-D_FILE_OFFSET_BITS=64-D_LARGEFILE_SOURCE-fno-strict-aliasing-fwrapv gcc-pthread-sharedbuild/temp.linux-x86_64-2.7/_mysql.o-L/usr/lib64/mysql-L/usr/lib64-lmysqlclient_r-lz-lpthread-lcrypt-lnsl-lm-lpthread-lssl-lcrypto-obuild/lib.linux-x86_64-2.7/_mysql.so SuccessfullyinstalledMySQL-python Cleaningup...