libmysqlclient.so.18: cannot open shared object file

libmysqlclient.so.18: cannot open shared object file

　　解决libmysqlclient.so.18: cannot open shared object file: no such file or directory failed问题
在启动php或者使用其他诸如pt等工具时，提示libmysqlclient.so.18: cannot open shared object file: no such file or directory failed问题
主要是安装方式导致的在默认的路径下没有对应的库连接文件。

 

# 先查找到对应的文件路径

find / -name libmysqlclient.so

# 我这里是/home/mysql/mysql55_3306/lib/

# 只需要做如下操作即可。
ln -s /home/mysql/mysql55_3306/lib/libmysqlclient.so /usr/lib/
ln -s /home/mysql/mysql55_3306/lib/libmysqlclient.so.18 /usr/lib/

ln -s /home/mysql/mysql55_3306/lib/libmysqlclient.so /usr/lib64/
ln -s /home/mysql/mysql55_3306/lib/libmysqlclient.so.18 /usr/lib64/


附加：
如果是percona版本的mysql

我这里是5.7.21版本的percona mysql
ln -s /usr/local/mysql/lib/libperconaserverclient.so    /usr/lib64/libmysqlclient.so
ln -s /usr/local/mysql/lib/libperconaserverclient.so.20 /usr/lib64/libmysqlclient.so.20

ln -s /usr/local/mysql/lib/libperconaserverclient.so    /usr/lib/libmysqlclient.so
ln -s /usr/local/mysql/lib/libperconaserverclient.so.20 /usr/lib/libmysqlclient.so.20