openEuler22.03解决mysql报错:error while loading shared libraries: libprotobuf-lite.so.3.19.4

现象描述：

服务器启动MySQL8服务失败，报错mysqld[5304]: /usr/sbin/mysqld: error while loading shared libraries: libprotobuf-lite.so.3.19.4: cannot open sh

可能原因：

此台机器之前有lib64目录丢失的故障，虽然从其他机器拷贝了，但不确定此台机器之前安装的软件有没有依赖库在原来删掉的lib64。根据报错很有可能是这个原因

定位思路：

对比其他安装了同样MySQL版本的机器，找到报错提示的lib库

故障机器：

[root@localhost ~]# find /* -name 'libproto*'
[root@localhost ~]# 

其他完好机器：

[root@localhost ~]# find /* -name 'libproto*'
/usr/lib64/mysql/private/libprotobuf-lite.so.3.19.4
/usr/lib64/mysql/private/libprotobuf.so.3.19.4

发现完好机器上在/lib64目录下是有整个的mysql目录的，保险期间，将完好机器上的/usr/lib64/mysql打包，传输到故障机器上。

处理步骤：

完好机器：

[root@localhost lib64]# tar -zcvf mysql.tar.gz mysql/
[root@localhost lib64]# mv mysql.tar.gz /root/
[root@localhost lib64]# cd
[root@localhost ~]# ll
总用量 48M
-rw-r--r--. 1 root root  48M 11月 16 17:36 mysql.tar.gz
[root@localhost ~]# scp -r mysql.tar.gz root@192.168.137.14:/usr/lib64/
The authenticity of host '192.168.137.14 (192.168.137.14)' can't be established.
ED25519 key fingerprint is SHA256:s549mRQXqy05laDu+jYc7E1wPQohIV4Yool/thDzxjY.
This key is not known by any other names
Are you sure you want to continue connecting (yes/no/[fingerprint])? t^Hyes
Please type 'yes', 'no' or the fingerprint: yes
Warning: Permanently added '192.168.137.14' (ED25519) to the list of known hosts.
​
Authorized users only. All activities may be monitored and reported.
root@192.168.137.14's password: 
mysql.tar.gz                                                                                                          100%   48MB 343.8MB/s   00:00  

故障机器：

[root@localhost yum.repos.d]# cd /usr/lib64
[root@localhost lib64]# tar xf mysql.tar.gz 
[root@localhost lib64]# rm -f mysql.tar.gz 
[root@localhost lib64]# ll mysql*
lrwxrwxrwx 1 root root   25  9月 14 01:57 libmysqlclient.so.21 -> libmysqlclient.so.21.2.31
-rwxr-xr-x 1 root root 7.3M  9月 14 02:09 libmysqlclient.so.21.2.31
drwxr-xr-x 4 root root 4.0K  9月 14 01:57 mecab
drwxr-xr-x 2 root root 4.0K 11月 16 17:20 plugin
drwxr-xr-x 3 root root 4.0K 11月 16 17:20 private

重启MySQL

[root@localhost ~]# systemctl restart mysqld
[root@localhost ~]# systemctl status mysqld
● mysqld.service - MySQL Server
     Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
     Active: active (running) since Wed 2022-11-16 17:46:50 CST; 4s ago
       Docs: man:mysqld(8)
             http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 5617 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
   Main PID: 5640 (mysqld)
     Status: "Server is operational"
      Tasks: 39 (limit: 8745)
     Memory: 458.2M
     CGroup: /system.slice/mysqld.service
             └─5640 /usr/sbin/mysqld
​
11月 16 17:46:49 localhost.localdomain systemd[1]: Starting MySQL Server...
11月 16 17:46:50 localhost.localdomain systemd[1]: Started MySQL Server.

已恢复~！

参考信息：

无