CentOS 7 离线安装MySQL8.x

由于服务器不能联网，需要离线安装一些服务。

官方下载MySQL8.x

地址：https://downloads.mysql.com/archives/community/ 选择对应的安装包

准备安装的组件

解压以后会发现好多安装包，我们只需要其中的几个。我们找出来，上传到服务器

安装顺序

1. mysql-community-common
2. mysql-community-client-plugins
3. mysql-community-libs
4. mysql-community-client
5. mysql-community-icu-data-files
6. mysql-community-server

开始安装

1. 查询与MySQL有冲突的mariadb包，并将其删除

rpm -qa|grep mariadb
> mariadb-libs-5.5.68-1.el7.aarch64
# nodeps 忽略依赖，强制删除
rpm -e --nodeps mariadb-libs
# 再次查询
rpm -qa|grep mariadb

rpm -ivh mysql-community-common-8.0.31-1.el7.x86_64.rpm rpm -ivh mysql-community-client-plugins-8.0.31-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-8.0.31-1.el7.x86_64.rpm rpm -ivh mysql-community-client-8.0.31-1.el7.x86_64.rpm rpm -ivh mysql-community-icu-data-files-8.0.31-1.el7.x86_64.rpm rpm -ivh mysql-community-server-8.0.31-1.el7.x86_64.rpm --force --nodeps 安装mysql-community-server包出现下面的错误 [root@localhost mysql8.0.31]# rpm -ivh mysql-community-server-8.0.31-1.el7.aarch64.rpm warning: mysql-community-server-8.0.31-1.el7.aarch64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY error: Failed dependencies: /usr/bin/perl is needed by mysql-community-server-8.0.31-1.el7.aarch64 net-tools is needed by mysql-community-server-8.0.31-1.el7.aarch64 perl(Getopt::Long) is needed by mysql-community-server-8.0.31-1.el7.aarch64 perl(strict) is needed by mysql-community-server-8.0.31-1.el7.aarch64 解决方法：

1. 这是由于需要一些依赖，我们可以将其忽略在安装命令后面加上–force –nodeps
2. 安装这些依赖 yum install net-tools yum install -y perl-Module-Install.noarch # 然后进行安装 rpm -ivh mysql-community-server-8.0.28-1.el7.x86_64.rpm

2. 设置开机自启动 systemctl enable mysqld

MySQL初始化

• 安装完成以后，需要对MySQL服务进行初始化 mysqld --initialize --console ⚠️出现mysq安装错误：error while loading shared libraries: libaio.so.1: cannot open shared object file: No such 解决办法：yum install -y libaio
• 初始化完成以后，进行用户组的权限设置，将MySQL目录进行设置 chown -R mysql:mysql /var/lib/mysql/
• 启动服务 systemctl start mysqld 查询一下初始化的密码 cat /var/log/mysqld.log | grep localhost > A temporary password is generated for root@localhost: SmnDiV)1dIfP 初始化密码：SmnDiV)1dIfP
• 登录MySQL mysql -uroot -p 修改我们的初始化密码 mysql> alter user 'root'@localhost identified by 'SmnRiV!2dIfP'; Query OK, 0 rows affected (0.01 sec) 授权其他访问IP，访问 use mysql update user set host=’%’ where user =’root’; FLUSH PRIVILEGES; GRANT ALL PRIVILEGES ON . TO ‘root’@’%’WITH GRANT OPTION; 重新登录

恭喜你安装成功