CentOS7.9 Mysql离线安装

卸载预装应用Mariadb

查看是否安装Mariadb

若有搜索结果则执行后续操作，若无则跳过该项

rpm -qa | grep mariadb*

停止相关服务

systemctl stop mariadb.service
systemctl disable mariadb.service

使用yum卸载Mariadb

yum remove -y mariadb*

删除相关配置文件

find / -name "mysql*" | xargs rm -rf
find / -name "mariadb*" | xargs rm -rf

确认是否有卸载残留

rpm -qa | grep mariadb
find / -name mariadb*

卸载预装Mysql

查看是否安装mysql

若有搜索结果则执行后续操作，若无则跳过该项

rpm -qa | grep mysql

停止相关服务

systemctl status mysqld
systemctl stop mysqld

删除Mysql文件

find / -name mysql

查看所有Mysql文件，确认是否可以全部删除，若可以则执行下述命令

find / -name mysql | xargs rpm -ev
rpm -qa | grep -i mysql

卸载Mysql

rmp -qa | grep -i mysql | xargs rpm -ev
rpm -qa | grep -i mysql

检出是否完全卸载

输出内容为找不到该服务则完全卸载

systemctl start mysql
systemctl start mysqld

离线安装Mysql

查看系统版本

cat /etc/system-release

根据系统版本去官网下载离线安装包'mysql-.el.x*.rpm-bundle.tar'

将安装包上传至linux

路径：/opt

解压安装包

tar -xvf /opt/mysql-8.0.37-1.el7.x86_64.rpm-bundle.tar

安装

rpm -ivh /opt/mysql-community-common-8.0.37-1.el7.x86_64.rpm
rpm -ivh /opt/mysql-community-client-plugins-8.0.37-1.el7.x86_64.rpm
rpm -ivh /opt/mysql-community-libs-8.0.37-1.el7.x86_64.rpm
rpm -ivh /opt/mysql-community-client-8.0.37-1.el7.x86_64.rpm
rpm -ivh /opt/mysql-community-icu-data-files-8.0.37-1.el7.x86_64.rpm
rpm -ivh /opt/mysql-community-server-8.0.37-1.el7.x86_64.rpm

若在安装server包时遇到以下报错时则需要安装libaio包

[root@homePros opt]# rpm -ivh /opt/mysql-community-server-8.0.41-1.el7.x86_64.rpm 
warning: /opt/mysql-community-server-8.0.41-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
error: Failed dependencies:
	libaio.so.1()(64bit) is needed by mysql-community-server-8.0.41-1.el7.x86_64
	libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-8.0.41-1.el7.x86_64
	libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-8.0.41-1.el7.x86_64

解决方案：

yum install -y libaio

初始化Mysql

mysqld --initialize --console

添加用户组

groupadd mysql
useradd -r -g mysql mysql

为目录赋权

chown -R mysql:mysql /var/lib/mysql

启动Mysql服务

systemctl start mysqld
systemctl status mysqld

查看初始root密码

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

设置root免密登录

该步骤可忽略

cp /etc/my.cnf /etc/my_bak.cnf
echo 'skip-grant-tables' >> /etc/my.cnf
service mysqld restart

登录Mysql

改步骤提示输入密码时若配置了免密登录则直接回车即可，若未配置则需要输入通过步骤9获取的初始密码后回车

mysql -uroot -p

修改root密码

flush privileges;
alter user 'root'@'localhost' identified by 'root2024';

配置root远程登录

use mysql
update user set host = '%' where user = 'root';
exit;

取消root免密登录

rm -rf /etc/my.cnf
cp /etc/my_bak.cnf /etc/my.cnf
service mysqld restart
mysql -uroot -proot2024
flush privileges;
exit;

删除安装包文件

rm -rf /opt/mysql-com*