libmysqlclient.so.16未找到方法
2024-08-25 03:45:24
用mysql命令登录的时候报错:
[root@iZ www]# mysql -uroot -p
mysql: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
搜索 libmysqlclient.so.16 但是没有找到这个文件
[root@iZ www]# locate libmysqlclient.so
/data/db_include/mysql5.7/lib/libmysqlclient.so
/data/db_include/mysql5.7/lib/libmysqlclient.so.20
/data/db_include/mysql5.7/lib/libmysqlclient.so.20.3.4
[root@iZ www]# locate libmysqlclient.so.16
[root@iZ www]# locate libmysqlclient.so.16
网上下载了一个 libmysqlclient.so.16 64位的放在了/usr/lib64目录下 下载地址
[root@iZ www]# rpm -qa | grep Percona
[root@iZ www]# ldd /usr/bin/mysql
/usr/bin/mysql: /usr/lib64/libmysqlclient.so.16: no version information available (required by /usr/bin/mysql)
linux-vdso.so.1 => (0x00007ffd753d8000)
libncursesw.so.5 => /lib64/libncursesw.so.5 (0x00007f4d9a17e000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f4d99f60000)
libmysqlclient.so.16 => /usr/lib64/libmysqlclient.so.16 (0x00007f4d99b03000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f4d998cc000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f4d996b2000)
libssl.so.10 => /usr/lib64/libssl.so.10 (0x00007f4d99446000)
libcrypto.so.10 => /usr/lib64/libcrypto.so.10 (0x00007f4d99061000)
libz.so.1 => /lib64/libz.so.1 (0x00007f4d98e4a000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f4d98b44000)
libm.so.6 => /lib64/libm.so.6 (0x00007f4d988c0000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f4d986a9000)
libc.so.6 => /lib64/libc.so.6 (0x00007f4d98315000)
libtinfo.so.5 => /lib64/libtinfo.so.5 (0x00007f4d980f4000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f4d97eef000)
/lib64/ld-linux-x86-64.so.2 (0x00007f4d9a3b2000)
librt.so.1 => /lib64/librt.so.1 (0x00007f4d97ce7000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007f4d97ae4000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f4d9789f000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f4d975b8000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f4d973b4000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f4d97187000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f4d96f7c000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f4d96d78000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f4d96b5e000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f4d9693f000)
继续登录发现还是报错
[root@iZ www]# mysql
mysql: /usr/lib64/libmysqlclient.so.16: no version information available (required by mysql)
mysql: relocation error: mysql: symbol disabled_my_option, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference
最后解决方法:
原来是以前的文件/usr/bin/mysql没替换的原因
用以下二条命令搞定了。
cd /usr/bin
mv mysql mysql.rpmbak
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
再次登录:
[root@iZ bin]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
参考文档: libmysqlclient问题
最新文章
- Can't find any matching row in the user table
- eclipse发布项目时,会自动还原server.xml和content.xml文件
- 让WinForm窗体的大小固定,不能调整大小
- Umbraco Forms 中的Recaptcha遇到的问题
- nginx 详解
- bzoj1681[Usaco2005 Mar]Checking an Alibi 不在场的证明
- initEvent vs initMouseEvent
- C++中socket编程
- IIS的php环境配置
- JavaScript原生对象总纲
- 移动端-手机端-日历选择控件(支持Zepto和JQuery)
- go语言使用xpath
- day1 计算机组成、操作系统
- 查看MySQL版本的命令及常用命令
- VisualSVN Server如何安装和使用
- 设计模式《JAVA与模式》之备忘录模式
- 团队作业——Beta冲刺3
- Facebook的Fairseq模型详解(Convolutional Sequence to Sequence Learning)
- mybatise 动态sql
- MySQL篇之Navicat可视化工具
热门文章
- linux中断和异常睡眠问题
- Glassfish Password Alias
- [USACO08FEB]酒店Hotel 线段树 BZOJ 1593
- Android----获取包名和sh1
- [Ruby]转载: 关于ruby中 %Q, %q, %W, %w, %x, %r, %s 的用法
- sql 日期对比
- SprimgMVC学习笔记(七)—— 上传图片
- Petya and Origami
- codeforces-984D——XOR-pyramid(DP)
- linux 的 sftp 和 scp