mysql客户端登录时报mysql: relocation error错误

报错内容:
[root@localhost ~]# mysql -u root -p
mysql: relocation error: mysql: symbol strmov, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference

解决方法:

查看该库文件是否存在

[root@localhost ~]# find / -name libmysqlclient.so.16
/usr/lib64/libmysqlclient.so.16

查看mysql命令运行时所需要的库文件

[root@localhost ~]# ldd /usr/bin/mysql
linux-vdso.so.1 => (0x00007fffe3fff000)
libncursesw.so.5 => /lib64/libncursesw.so.5 (0x00007f387380c000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f38735ee000)
libmysqlclient.so.16 => /usr/lib64/libmysqlclient.so.16 (0x00007f387327f000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f3873048000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f3872e2e000)
libssl.so.10 => /usr/lib64/libssl.so.10 (0x00007f3872bc2000)
libcrypto.so.10 => /usr/lib64/libcrypto.so.10 (0x00007f38727df000)
libz.so.1 => /lib64/libz.so.1 (0x00007f38725c8000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f38722c2000)
libm.so.6 => /lib64/libm.so.6 (0x00007f387203e000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f3871e27000)
libc.so.6 => /lib64/libc.so.6 (0x00007f3871a93000)
libtinfo.so.5 => /lib64/libtinfo.so.5 (0x00007f3871872000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f387166d000)
/lib64/ld-linux-x86-64.so.2 (0x00007f3873a4b000)
librt.so.1 => /lib64/librt.so.1 (0x00007f3871465000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007f3871262000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f387101d000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f3870d37000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f3870b33000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f3870906000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f38706fb000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f38704f7000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f38702dd000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f38700be000)

从上面可以看到该文件已存在,并且已被调用

3.查看系统中是否安装了Percona软件包

[root@localhost ~]# rpm -qa | grep Percona
Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6.x86_64

4.将该软件包卸载掉

[root@localhost ~]# rpm -e Percona-Server-shared-51-5.1.73 --nodeps

5.禁用percona的软件源

[root@localhost ~]# cd /etc/yum.repos.d
[root@localhost yum.repos.d]# ls
CentOS-Base.repo CentOS-Debuginfo.repo CentOS-fasttrack.repo CentOS-Media.repo CentOS-Vault.repo epel.repo epel-testing.repo percona-release.repo

[root@localhost yum.repos.d]# mv percona-release.repo percona-release.repo.disable

6.安装mysql-libs软件包

[root@localhost ~]# yum -y install mysql-libs

7.重新登录进行测试

[root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> exit

问题解决!

posted @ 2025-03-30 18:09  郑琰  阅读(41)  评论(0)    收藏  举报
#

# #