mysql: error while loading shared libraries: libssl.so.10

问题

CentOS8安装完MySQL查看MySQL版本时报错, libssl.so.10 缺失库文件

[root@hadoop102 mysql8.0.25]# mysqladmin --version
mysqladmin: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory
[root@hadoop102 mysql8.0.25]# mysql --version
mysql: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory

原因

这个错误消息表明在运行 MySQL 时，系统无法找到名为 libssl.so.10 的共享库文件. 这可能是由于缺少相应的库文件或库文件版本不匹配引起的

解决

安装openssl10 进行OpenSSL升级（用yum升不上去，用rpm包简单有效）

[root@hadoop102 Clash for Windows-0.17.1-x64-linux]# yum install openssl10
Extra Packages for Enterprise Linux 8 - x86_64                                                                                             1.4 MB/s |  16 MB     00:11    
Extra Packages for Enterprise Linux Modular 8 - x86_64                                                                                     278 kB/s | 733 kB     00:02    
上次元数据过期检查：0:00:01 前，执行于 2023年08月10日 星期四 14时45分45秒。
未找到匹配的参数: openssl10
错误：没有任何匹配: openssl10

下载rpm包:
https://mirrors.aliyun.com/centos/8/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm
安装rpm包:

[root@hadoop102 mysql8.0.25]# rpm -i compat-openssl10-1.0.2o-3.el8.x86_64.rpm 
错误：依赖检测失败：
	make 被 compat-openssl10-1:1.0.2o-3.el8.x86_64 需要
[root@hadoop102 mysql8.0.25]# rpm -i compat-openssl10-1.0.2o-3.el8.x86_64.rpm --nodeps --force
[root@hadoop102 mysql8.0.25]# mysqladmin --version
mysqladmin  Ver 8.0.25 for Linux on x86_64 (MySQL Community Server - GPL)

仍有报错:
参考 https://blog.csdn.net/m0_51197424/article/details/129410878 和 https://blog.csdn.net/weixin_43672348/article/details/127522346

[root@hadoop102 mysql8.0.25]# mysql --version
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
[root@hadoop102 mysql8.0.25]# cp /usr/lib64/libncurses.so.6 /usr/lib64/libncurses.so.5
[root@hadoop102 mysql8.0.25]# mysql --version
mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory
[root@hadoop102 mysql8.0.25]# cp /usr/lib64/libtinfo.so.6 /usr/lib64/libtinfo.so.5
[root@hadoop102 mysql8.0.25]# mysql --version
mysql  Ver 8.0.25 for Linux on x86_64 (MySQL Community Server - GPL)

参考: Linux安装MySQL8.0常见问题_知乎