Mysql8.0.30离线安装

---

Mysql8离线安装

内网服务器不用使用yum直接安装mysql，很痛苦，记录一下安装过程

---

一、下载地址

传送门mysql8.0.30
官网 选择自己需要的版本

二、安装步骤

1.移除mariadb

#查找
rpm -qa|grep mariadb
#移除
rpm -e --nodeps mariadb-libs

2.安装mysql

上传tar包到/opt下，并解压缩mysql离线安装包

cd /opt
# 解压
tar -xvf mysql-8.0.30-1.el7.x86_64.rpm-bundle.tar
# 安装顺序
rpm -ivh mysql-community-common-8.0.30-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-plugins-8.0.30-1.el7.x86_64.rpm 
rpm -ivh mysql-community-libs-8.0.30-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.30-1.el7.x86_64.rpm 
rpm -ivh mysql-community-server-8.0.30-1.el7.x86_64.rpm
# 如果安装失败，执行以下命令（见下文图）
yum install -y perl-Module-Install.noarch

# 非必要安装(本人部分未安装)
rpm -ivh mysql-community-devel-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.30-1.el7.x86_64.rpm 
rpm -ivh mysql-community-debuginfo-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-debug-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-test-8.0.30-1.el7.x86_64.rpm

解压缩之后，包含以下rpm包

报错截图

3.配置mysql

1. 检查是否开机启动

systemctl list-unit-files|grep mysqld

显示以下为开机启动

如果没有设置为开机启动则执行

systemctl enable mysqld.service

2. 启动mysql

# 启动
systemctl start mysqld
# 查看状态
systemctl status mysqld

3. 配置root
查看MySQL初始默认密码
grep 'temporary password' /var/log/mysqld.log

通过初始密码登录

mysql -u root -p

修改新密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '密码(需包含大小写特殊字符)';

开启MySQL远程连接

mysql> use mysql;

修改root账户权限

mysql> update user set host = '%' where user = 'root';

刷新权限

mysql> flush privileges;

查看默认编码

mysql> show variables like 'character%';

总结

希望对大家有所帮助