Ubuntu下Python连接mysql时报错：ImportError: libmysqlclient.so.18: cannot open shared object file

Ubuntu下Python连接mysql时报错，错误内容如下：

import _mysql ImportError: libmysqlclient.so.18: cannot open shared object file:

解决办法一，软连接

locate libmysqlclient
from . import _mysql ImportError: libmysqlclient.so.18
sudo ln -s /usr/local/mysql/lib/libmysqlclient.so.20 /usr/lib64/libmysqlclient.so.18

参考：

• https://blog.csdn.net/tyutzhangyukang/article/details/78613246
• https://www.cnblogs.com/havenshen/p/3531489.html
• https://www.cnblogs.com/xueweihan/p/9081429.html
• https://blog.csdn.net/default7/article/details/82312606

实测：无效

解决办法二，添加  /usr/local/mysql/lib  到   /etc/ld.so.conf  文件里

参考：

• https://blog.csdn.net/m0_37886429/article/details/78350343
• http://www.voidcn.com/article/p-foyuyayj-qa.html
• https://stackoverflow.com/questions/45706096/version-libmysqlclient-20-0-not-found

实测：无效

解决办法三，sudo apt-get install libmysqlclient-dev (或 libmysqlclient20-dev 之类的)

实测：无效，因为已经安装好了

参考：

• https://stackoverflow.com/questions/42152729/error-installing-mysqlclient-on-ubuntu-16-04-using-pip-and-python-3-6

解决办法四，pip install --no-binary mysqlclient mysqlclient

参考：

• https://stackoverflow.com/questions/36796167/upgraded-to-ubuntu-16-04-now-mysql-python-dependencies-are-broken

实测：奏效了！！！厉害厉害！

另外注意

conda install mysqlclinet 的版本存在 open_ssl 的版本不兼容问题，不能用。只能用 pip 版的 mysqlclient