mysql报错集锦
系统环境
docker centos:8
报错信息1
mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such
[root@9039691e1444 bin]# mysql -S /tmp/mysql.sock
mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory
解决办法
cd /usr/local/mysql/bin
$ sudo ldd mysql
linux-vdso.so.1 (0x00007ffdd7bf7000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f7fe4a51000)
libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007f7fe47bd000)
libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007f7fe42d7000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f7fe40d3000)
libtinfo.so.5 => not found
libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f7fe3d3e000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f7fe3b26000)
libc.so.6 => /lib64/libc.so.6 (0x00007f7fe3763000)
/lib64/ld-linux-x86-64.so.2 (0x00007f7fe53a7000)
libz.so.1 => /lib64/libz.so.1 (0x00007f7fe354c000)
libm.so.6 => /lib64/libm.so.6 (0x00007f7fe31ca000)
发现libtinfo.so.5 => not found
查看此目录,如果此目录有的话,直接将lib文件copy
ls /lib/x86_64-linux-gnu/libtinfo.so.*
cp /lib/x86_64-linux-gnu/libtinfo.so.5 /lib64/
如果没有,下载
我的是在docker环境
docker cp libtinfo.so.5 9039691e1444:/lib64/
[root@9039691e1444 bin]# ldd mysql
linux-vdso.so.1 (0x00007fffcf9d8000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f4a3233d000)
libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007f4a320a9000)
libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007f4a31bc3000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f4a319bf000)
libtinfo.so.5 => /lib64/libtinfo.so.5 (0x00007f4a31795000)
libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f4a31400000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f4a311e8000)
libc.so.6 => /lib64/libc.so.6 (0x00007f4a30e25000)
/lib64/ld-linux-x86-64.so.2 (0x00007f4a32c93000)
libz.so.1 => /lib64/libz.so.1 (0x00007f4a30c0e000)
libm.so.6 => /lib64/libm.so.6 (0x00007f4a3088c000)
解决!
更新于2021-04-26
报错信息2
解决 “/lib64/libc.so.6: version `GLIBC_2.18’ not found (required by /lib64/libstdc++.so.6)”
解决方法:
curl -O http://ftp.gnu.org/gnu/glibc/glibc-2.18.tar.gz
tar zxf glibc-2.18.tar.gz
cd glibc-2.18/
mkdir build
cd build/
../configure --prefix=/usr
make -j4
# 编译时间较长,在10分钟左右
make install