python2.7安装MySQLdb报错

Question

python2.7安装MySQLdb报错
报错信息如下:

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
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'
writing manifest file 'MySQL_python.egg-info/SOURCES.txt'
installing library code to build/bdist.linux-i686/egg
running install_lib
running build_py
copying MySQLdb/release.py -> build/lib.linux-i686-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,4,'beta',4) -D__version__=1.2.4b4 -I/usr/include/mysql -I/usr/local/include/python2.7 -c _mysql.c -o build/temp.linux-i686-2.7/_mysql.o -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -fasynchronous-unwind-tables -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1
In file included from _mysql.c:44:
/usr/include/mysql/my_config.h:422:1: warning: "HAVE_WCSCOLL" redefined
In file included from /usr/local/include/python2.7/Python.h:8,
                 from _mysql.c:29:
/usr/local/include/python2.7/pyconfig.h:917:1: warning: this is the location of the previous definition
gcc -pthread -shared build/temp.linux-i686-2.7/_mysql.o -L/usr/lib -lmysqlclient_r -lpthread -lm -lrt -ldl -o build/lib.linux-i686-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

Answer 1

/usr/bin/ld: cannot find -lmysqlclient_r
collect2: ld returned 1 exit status

链接出错，没找到名叫 mysqlclient_r 的库。你需要安装 mysql-clients（libmariadbclient，或者类似名字）的软件包。如果你告诉我们你正在使用的操作系统/发行版的话，我可能可以给你更具体的处理办法。

Answer 2

1.下载MySQL-python

2.下载setuptools

解压安装

python setup.py build
python setup.py install

3.返回解压出来的MySQL-python文件夹中

python setup.py build
python setup.py install