MySQL Client login times mysql:relocation error errors

After installing Xtrabackup, use the following command to log in to the times the following error

[Email protected] ~]# mysql-u root-p
Mysql:relocation error:mysql:symbol Strmov, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with Lin K Time Reference

Workaround:

2. See if the library file exists

   [Email protected] ~]# Find/-name libmysqlclient.so.16
   /usr/lib64/libmysqlclient.so.16

3. View the library files required to run the MySQL command

   [Email protected] ~]# 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)

   From the above you can see that the file already exists and has been called

3. Check if the Percona package is installed in the system

[Email protected] ~]# Rpm-qa | grep Percona
Percona-server-shared-51-5.1.73-rel14.12.624.rhel6.x86_64

4. Uninstall the package

[Email protected] ~]# rpm-e percona-server-shared-51-5.1.73--nodeps

5. Disabling the Percona software source

[Email protected] ~]# CD/ETC/YUM.REPOS.D
[[email protected] yum.repos.d]# ls
Centos-base.repo Centos-debuginfo.repo centos-fasttrack.repo centos-media.repo CentOS-Vault.repo Epel.repo epel-test Ing.repo Percona-release.repo

[Email protected] yum.repos.d]# MV Percona-release.repo percona-release.repo.disable

6. Installing the Mysql-libs Package

[Email protected] ~]# yum-y install Mysql-libs
Loaded Plugins:fastestmirror, Refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
* base:mirrors.yun-idc.com
* epel:mirrors.yun-idc.com
* extras:mirrors.yun-idc.com
* Updates:mirrors.btte.net
Resolving Dependencies
--Running Transaction check
---> Package mysql-libs.x86_64 0:5.1.73-3.el6_5 'll be installed
--Finished Dependency Resolution

Dependencies resolved

=============================================================================================================== ==============================================
Package Arch Version Repos Itory Size
=============================================================================================================== ==============================================
Installing:
Mysql-libs x86_64 5.1.73-3.el6_5 Base 1.2 M

Transaction Summary
=============================================================================================================== ==============================================
Install 1 package (s)

Total Download size:1.2 M
Installed size:4.0 M
Downloading Packages:
mysql-libs-5.1.73-3.el6_5.x86_64.rpm | 1.2 MB 00:07
Running Rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning:rpmdb altered outside of Yum.
* * Found pre-existing Rpmdb problem (s), ' yum check ' output follows:
Mysql-5.1.73-3.el6_5.x86_64 has missing requires of libmysqlclient.so.16 () (64bit)
Mysql-5.1.73-3.el6_5.x86_64 has missing requires of libmysqlclient.so.16 (LIBMYSQLCLIENT_16) (64bit)
Mysql-5.1.73-3.el6_5.x86_64 has missing requires of libmysqlclient_r.so.16 () (64bit)
Mysql-5.1.73-3.el6_5.x86_64 has missing requires of libmysqlclient_r.so.16 (LIBMYSQLCLIENT_16) (64bit)
Mysql-5.1.73-3.el6_5.x86_64 has missing requires of mysql-libs = (' 0 ', ' 5.1.73 ', ' 3.el6_5 ')
Mysql-devel-5.1.73-3.el6_5.x86_64 has missing requires of libmysqlclient.so.16 () (64bit)
Mysql-devel-5.1.73-3.el6_5.x86_64 has missing requires of libmysqlclient_r.so.16 () (64bit)
Mysql-server-5.1.73-3.el6_5.x86_64 has missing requires of libmysqlclient.so.16 () (64bit)
Mysql-server-5.1.73-3.el6_5.x86_64 has missing requires of libmysqlclient.so.16 (LIBMYSQLCLIENT_16) (64bit)
Mysql-server-5.1.73-3.el6_5.x86_64 has missing requires of libmysqlclient_r.so.16 () (64bit)
Mysql-server-5.1.73-3.el6_5.x86_64 has missing requires of libmysqlclient_r.so.16 (LIBMYSQLCLIENT_16) (64bit)
Perl-dbd-mysql-4.013-3.el6.x86_64 has missing requires of libmysqlclient.so.16 () (64bit)
Perl-dbd-mysql-4.013-3.el6.x86_64 has missing requires of libmysqlclient.so.16 (LIBMYSQLCLIENT_16) (64bit)
2:postfix-2.6.6-6.el6_5.x86_64 has missing requires of libmysqlclient.so.16 () (64bit)
2:postfix-2.6.6-6.el6_5.x86_64 has missing requires of libmysqlclient.so.16 (LIBMYSQLCLIENT_16) (64bit)
2:postfix-2.6.6-6.el6_5.x86_64 has missing requires of mysql-libs
Installing:mysql-libs-5.1.73-3.el6_5.x86_64 1/1
  verifying : mysql-libs-5.1.73-3.el6_5.x86_64                                                                                                                1/1

Installed:
Mysql-libs.x86_64 0:5.1.73-3.el6_5

complete!

7. Re-login to test

[Email protected] ~]# 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) and/or, Oracle, its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

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

Mysql> exit

Problem Solving!

This article is from the "Cloud Life" blog, make sure to keep this source http://ovcer.blog.51cto.com/1145188/1620051

MySQL Client login times mysql:relocation error errors