ldconfig mysql_mysql: error while loading shared libraries: libmysqlclient.so.16

mysql卸载后重装报错：

[root@localhost]# mysql

mysql: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory

1. checking for libmysqlclient installed.

[root@node01 mysqli]# ldconfig -v | grep mysql

/usr/lib64/mysql:

libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0

libmysqlclient.so.16 -> libmysqlclient.so.16.0.0

[root@node01 mysqli]#

[root@node01 mysqli]#locate libmysqlclient.so

/usr/lib64/mysql/libmysqlclient.so

/usr/lib64/mysql/libmysqlclient.so.16

/usr/lib64/mysql/libmysqlclient.so.16.0.0

[root@node01 mysqli]#

if output empty then simply run these commands on rpm\yum based linux:1.17.0) 4.7.3 20121001 (prerelease)Copyright (C) 2012 Free Software Foundation, Inc.This is free software; see the source for copying conditions. There is NOwarranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. co

yum install mysql-devel mysql-libs

2. re-compile php-mysql module with path to lib64 folder.

./configure �with-php-config=/usr/local/php/bin/php-config �with-mysql=/usr/bin/ �with-libdir=lib64

3. alternative solution is:

[root@node01 mysql]#ln -s /usr/lib64/mysql/libmysqlclient.so /usr/lib/mysql/libmysqlclient.so

This entry was posted in CentOS, Fedora, Linux, MySQL, OS, RedHat by stealth. Bookmark the permalink.

talled it successfully on one system, but when I tried to install it on another, its throwing up some really random error. I initially installed mysql and made sure its running. Then I installed sysbench with the command: dnf install sysben