openEuler 22.03 LTS安装MySQL冲突

根本原因:缺少 libcrypto.so.10库文件,其中安装到第二个开始报错,报错内容如下。

weixin_51125521

336人浏览 · 2025-07-29 09:32:44

weixin_51125521 · 2025-07-29 09:32:44 发布

使用rpm包安装形式,安装命令:

sudo rpm -ivh mysql-community-common-8.0.30-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-libs-8.0.30-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-client-8.0.30-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-server-8.0.30-1.el7.x86_64.rpm

其中安装到第二个开始报错,报错内容如下

[root@ecs-a107-0714742 ~]# sudo rpm -ivh mysql-community-common-8.0.30-1.el7.x86_64.rpm
warning: mysql-community-common-8.0.30-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-common-8.0.30-1.e################################# [100%]
[root@ecs-a107-0714742 ~]# sudo rpm -ivh mysql-community-libs-8.0.30-1.el7.x86_64.rpm
warning: mysql-community-libs-8.0.30-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
error: Failed dependencies:
        libcrypto.so.10()(64bit) is needed by mysql-community-libs-8.0.30-1.el7.x86_64
        libcrypto.so.10(libcrypto.so.10)(64bit) is needed by mysql-community-libs-8.0.30-1.el7.x86_64
        libssl.so.10()(64bit) is needed by mysql-community-libs-8.0.30-1.el7.x86_64
        libssl.so.10(libssl.so.10)(64bit) is needed by mysql-community-libs-8.0.30-1.el7.x86_64
        mysql-community-client-plugins = 8.0.30-1.el7 is needed by mysql-community-libs-8.0.30-1.el7.x86_64

尝试使用安装命令安装(但失败):

根本原因:缺少 libcrypto.so.10库文件,
安装openssl可以解决:

wget http://mirror.centos.org/centos/8-stream/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-4.el8.x86_64.rpm
 
# 上面这个大概率报404，用这个
wget http://mirrors.aliyun.com/centos/8-stream/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-4.el8.x86_64.rpm
 
rpm -ivh compat-openssl10-1.0.2o-4.el8.x86_64.rpm --nodeps

然后使用systemctl start mysqld

使用systemctl status mysqld, 发现服务已经正常启动

尝试使用mysql客户端进行连接,发现连接报错如下:

解决方式如下:

创建符号链接：
由于 libtinfo.so.6 已经存在并且是较新的版本，你可以尝试手动创建 libtinfo.so.5 的符号链接。执行以下命令：

sudo ln -s /usr/lib64/libtinfo.so.6 /usr/lib64/libtinfo.so.5

验证符号链接, 执行以下命令验证链接是否成功：

ls -l /usr/lib64/libtinfo.so.5

输出应该类似于：

然后重启服务

sudo systemctl restart mysqld

然后尝试使用客户端连接 ,发现已经正常

更新配置以支持远程连接

UPDATE mysql.user SET host = '%' WHERE user = 'root' AND host = 'localhost';

FLUSH PRIVILEGES;

若生产环境,只想要指定ip访问

CREATE USER 'root'@'192.168.1.100' IDENTIFIED BY 'your_strong-password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.100' WITH GRANT OPTION;
FLUSH PRIVILEGES;