CentOS8.3离线安装MySQL5.7

从oracle官网下载MySQL Downloads。

使用SecureFX上传MySQL5.7离线安装包，将下载好的安装包直接拖拽进远程服务器的指定目录即可。

rpm -qa|grep -i mariadb
rpm -qa|grep -i mysql

tar -xf mysql-5.7.41-1.el7.x86_64.rpm-bundle.tar

按照如下命令顺序安装
1、注意在安装mysql-community-client-5.7.41-1.el7.x86_64.rpm时如果报缺少ibncurses.so和libtinfo.so依赖的错误，需要执行yum install libncurses* 命令来安装缺少的依赖。
2、注意在安装mysql-community-libs-compat-5.7.41-1.el7.x86_64.rpm时如果报缺少libcrypto.so和libssl.so依赖的错误，需要执行yum install compat-openssl10 命令来安装缺少的依赖。

rpm -ivh mysql-community-common-5.7.41-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.41-1.el7.x86_64.rpm
yum install libncurses*
rpm -ivh mysql-community-client-5.7.41-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.41-1.el7.x86_64.rpm
yum install compat-openssl10
rpm -ivh mysql-community-libs-compat-5.7.41-1.el7.x86_64.rpm 

systemctl start mysqld

systemctl stop mysqld

systemctl enable mysqld

systemctl restart mysqld

systemctl status mysqld

grep 'temporary password' /var/log/mysqld.log

首先使用前面查询到的root用户密码登陆mysql

mysql -uroot -p

降低mysql密码认证严格程度，然后修改密码

set global validate_password_policy=0; 
set global validate_password_length=1;
ALTER USER 'root'@'localhost' IDENTIFIED BY '你想设置的密码';

select version();

show databases;

use mysql;

修改指定数据库实例的字符集

ALTER DATABASE mysql CHARACTER SET utf8;

修改数据库实例中指定表的字符集，这里以修改mysql数据库实例中的user表为例

use mysql;
ALTER TABLE user CONVERT TO CHARACTER SET utf8;

首先设置任意IP地址都可以访问mysql数据库

update user set Host='%' where User='root';
flush privileges;

然后为mysql开放防火墙端口，mysql协议默认端口号是3306

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

最终测试连接成功

查看是否安装过mariadb和mysql

rpm -qa|grep -i mariadb
rpm -qa|grep -i mysql

使用如下命令顺序卸载

rpm -e --nodeps mysql-community-common-5.7.41-1.el7.x86_64
rpm -e --nodeps mysql-community-client-5.7.41-1.el7.x86_64
rpm -e --nodeps mysql-community-libs-5.7.41-1.el7.x86_64
rpm -e --nodeps mysql-community-server-5.7.41-1.el7.x86_64
rpm -e --nodeps mysql-community-libs-compat-5.7.41-1.el7.x86_64

再次查看是否卸载干净

rpm -qa|grep -i mysql

删除mysql配置文件

rm -rf /etc/my.cnf

删除mysql日志文件

rm -rf /var/log/mysqld*.log

找出并逐一删除其余残余的mysql文件

find / -name mysql