MySQLdb importerror:libmysqlclient.so.18 Solution Method _python

After installing MYSQLDB, the import mysqldb error follows:

Copy Code code as follows:

[Root@lizhong mysql-python-1.2.3]#/usr/local/bin/python2.7
Python 2.7.6 (Default, APR 10 2014, 15:45:39)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] on linux2
Type ' help ', ' copyright ', ' credits ' or ' license ' for the more information.
>>> Import MySQLdb
/usr/local/lib/python2.7/site-packages/mysql_python-1.2.3-py2.7-linux-x86_64.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from/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.3 is being added to Sys.path
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "mysqldb/__init__.py", line, in <module>
Import _mysql
File "build/bdist.linux-x86_64/egg/_mysql.py", line 7, in <module>
File "build/bdist.linux-x86_64/egg/_mysql.py", line 6, in __bootstrap__
Importerror:libmysqlclient.so.18:cannot open Shared object file:no such file or directory

According to the last hint, should be unable to find a libmysqlclient.so.18 file, so go to the MySQL installation directory to find this file and make a soft connection to/usr/lib

Copy Code code as follows:

Ln-s/usr/local/mysql/lib/libmysqlclient.so.18/usr/lib/libmysqlclient.so.18

If the 64 system is:

Copy Code code as follows:

Ln-s/usr/local/mysql/lib/libmysqlclient.so.18/usr/lib64/libmysqlclient.so.18

Again import MySQLdb is normal:

Copy Code code as follows:

[Root@lizhong mysql-python-1.2.3]#/usr/local/bin/python2.7
Python 2.7.6 (Default, APR 10 2014, 15:45:39)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] on linux2
Type ' help ', ' copyright ', ' credits ' or ' license ' for the more information.
>>> Import MySQLdb
>>>