Linux openEuler 安装 MySQL

更新记录

点击查看

2024年3月1日 更新常见问题。
2024年2月29日 发布。

安装需要使用到的命令和包

如果有就不用安装了。

yum -y install tar
yum -y install vim
yum -y install net-tools
yum -y install libncurses*

下载 MySQL 的安装包

官网地址：https://downloads.mysql.com/archives/community/

5.7版本

8.X 版本

下载到服务器

# 5.7
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.44-1.el7.x86_64.rpm-bundle.tar

# 8.2
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.2.0-1.el7.x86_64.rpm-bundle.tar

解压安装包

tar -xvf mysql-5.7.44-1.el7.x86_64.rpm-bundle.tar

按顺序安装包

分别安装common , libs, client, server服务

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

查看MySQL安装情况

rpm -qa | grep mysql

初始化数据库

mysqld --initialize --console

查看初始密码

cat /var/log/mysqld.log | grep password

启动 MySQL 服务

# 查看MySQL状态
systemctl status mysqld
# 启动 MySQL 服务
systemctl start mysqld
## 如果启动失败执行下面这个。然后再启动
chown -R mysql:mysql /var/lib/mysql
## 如果还是启动失败执行下面这个。然后再启动
chmod 777 /usr/sbin/mysqld
chmod 777 /usr/lib/mysql/*

首次登陆

mysql -uroot -p
#输入刚刚查询到的秘密

# 修改默认的密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

## 修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'very_strong_password';

# 允许root可以远程访问（危险）
use mysql;
update user set host='%' where user='root';

# 或者创建一个新用户(MySQL 8前)
GRANT ALL PRIVILEGES ON *.* TO panda@"%" IDENTIFIED BY 'very_strong_password' WITH GRANT OPTION;
# 或者创建一个新用户(MySQL 8后)
CREATE USER panda@'%' IDENTIFIED BY 'very_strong_password';
GRANT ALL PRIVILEGES ON *.* TO panda@"%" WITH GRANT OPTION;

## 刷新权限
FLUSH PRIVILEGES;

Linux 防火墙设置

# 设置防火墙开启3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
# 重启防火墙服务
systemctl restart firewalld.service

## 关闭防火墙（不需要执行，备用记录）
systemctl disable firewalld

常见问题

提示缺少libcrypto.so.10包

Failed dependencies:
	libcrypto.so.10()(64bit) is needed by mysql-community-server-8.2.0-1.el7.x86_64
	libcrypto.so.10(OPENSSL_1.0.1_EC)(64bit) is needed by mysql-community-server-8.2.0-1.el7.x86_64
	libcrypto.so.10(OPENSSL_1.0.2)(64bit) is needed by mysql-community-server-8.2.0-1.el7.x86_64
	libcrypto.so.10(libcrypto.so.10)(64bit) is needed by mysql-community-server-8.2.0-1.el7.x86_64
	libssl.so.10()(64bit) is needed by mysql-community-server-8.2.0-1.el7.x86_64
	libssl.so.10(libssl.so.10)(64bit) is needed by mysql-community-server-8.2.0-1.el7.x86_64
	mysql-community-icu-data-files = 8.2.0-1.el7 is needed by mysql-community-server-8.2.0-1.el7.x86_64

包查询查看：
https://centos.pkgs.org/8-stream/centos-appstream-x86_64/compat-openssl10-1.0.2o-3.el8.x86_64.rpm.html

解决办法：

# 安装系统对应架构的包
wget http://mirror.centos.org/centos/8-stream/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm
rpm -ivh compat-openssl10-1.0.2o-3.el8.x86_64.rpm

参考资料

https://www.openeuler.org/zh/blog/20220726-banqian-mysql/banqian-mysql.html
https://zhuanlan.zhihu.com/p/624316835
https://forum.openeuler.org/t/topic/1602
https://blog.csdn.net/sinat_20260363/article/details/128922998