MySQLdb ImportError: libmysqlclient.so.18解决方法
安装MySQLdb后,importMySQLdb出错如下:
[root@lizhongMySQL-python-1.2.3]#/usr/local/bin/python2.7 Python2.7.6(default,Apr102014,15:45:39) [GCC4.4.720120313(RedHat4.4.7-4)]onlinux2 Type"help","copyright","credits"or"license"formoreinformation. >>>importMySQLdb /usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/_mysql.py:3:UserWarning:Module_mysqlwasalreadyimportedfrom/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/_mysql.pyc,but/soft/MySQL-python-1.2.3isbeingaddedtosys.path Traceback(mostrecentcalllast): File"<stdin>",line1,in<module> File"MySQLdb/__init__.py",line19,in<module> import_mysql File"build/bdist.linux-x86_64/egg/_mysql.py",line7,in<module> File"build/bdist.linux-x86_64/egg/_mysql.py",line6,in__bootstrap__ ImportError:libmysqlclient.so.18:cannotopensharedobjectfile:Nosuchfileordirectory
根据最后提示,应该是找不着一个交libmysqlclient.so.18的文件,于是到mysql安装目录里找到这个文件并且做一个软连接到/usr/lib
ln-s/usr/local/mysql/lib/libmysqlclient.so.18/usr/lib/libmysqlclient.so.18
如果是64系统则:
ln-s/usr/local/mysql/lib/libmysqlclient.so.18/usr/lib64/libmysqlclient.so.18
再次importMySQLdb就正常了:
[root@lizhongMySQL-python-1.2.3]#/usr/local/bin/python2.7 Python2.7.6(default,Apr102014,15:45:39) [GCC4.4.720120313(RedHat4.4.7-4)]onlinux2 Type"help","copyright","credits"or"license"formoreinformation. >>>importMySQLdb >>>