Resolve MySQLdb importerror:libmysqlclient.so.18 Errors

After installing MYSQLDB, the import mysqldb error follows:

The code is as follows

Copy Code

[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

The code is as follows	Copy Code
Ln-s/usr/local/mysql/lib/libmysqlclient.so.18/usr/lib/libmysqlclient.so.18

If the 64 system is:

The code is as follows	Copy Code
Ln-s/usr/local/mysql/lib/libmysqlclient.so.18/usr/lib64/libmysqlclient.so.18

Again import MySQLdb is normal:

The code is as follows	Copy Code
[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 >>>

(End of this article)