mysql8.0的两种安装方式（rpm安装和yum安装）

一、rpm安装mysql:

第一步：先删除mysql的相关内容

rpm -qa | grep mariadb
rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps

第二步：安装引导包

这个软件mysql80-community-release-el7-4.noarch.rpm，它不是一个安装包，而是一个引导包

（modules是自己建的文件夹）

cd /opt/modules
yum install -y wget
wget https://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm

yum localinstall -y  mysql80-community-release-el7-4.noarch.rpm

第三步：安装mysql

yum install -y mysql-community-server

如果报错：

源 "MySQL 8.0 Community Server" 的 GPG 密钥已安装，但是不适用于此软件包。请检查源的公钥 URL 是否配置正确。

 失败的软件包是：mysql-community-client-8.0.28-1.el7.x86_64
 GPG  密钥配置为：file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

执行如下：

①执行命令：rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

②并且再次安装：yum install -y mysql-community-server
③假如还出问题，使用如下命令：yum install mysql-server --nogpgcheck

第四步：启动mysql服务

#1.启动MySQL
systemctl start mysqld

#2.查看初始密码
grep 'temporary password' /var/log/mysqld.log

#3.登陆mysql
mysql -uroot -p

#4.修改一个复杂的密码
alter user root@localhost identified by 'Y1h2e3d4u5!';

#如果想设置一个简单的的密码 修改mysql的密码校验规则
set global validate_password.policy=LOW;
set global validate_password.length=4;
set global validate_password.mixed_case_count=0;
set global validate_password.number_count=0;
set global validate_password.special_char_count=0;

alter user root@localhost identified by '123456';

#5.远程授权
create user 'root'@'%' identified by '123456';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;

 第五步：重启mysql的服务

service mysqld restart

二、yum安装mysql:

第一步：上传安装包，解压

安装包链接如下：

https://downloads.mysql.com/archives/community/

#进入安装包的目录
tar -xvf mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar -C /opt/installs

第二步：查看是否有mysql数据库并删除

rpm -qa | grep mariadb
rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps

第三步：依次安装所需服务

rpm -ivh mysql-community-common-8.0.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.26-1.el7.x86_64.rpm
yum install -y net-tools
yum install -y perl
yum install libaio
rpm -ivh mysql-community-server-8.0.26-1.el7.x86_64.rpm

第四步：启动mysql服务

#1.启动MySQL
systemctl start mysqld

#2.查看初始密码
grep 'temporary password' /var/log/mysqld.log

#3.登陆mysql
mysql -uroot -p

#4.修改一个复杂的密码
alter user root@localhost identified by 'Y1h2e3d4u5!';

#如果想设置一个简单的的密码 修改mysql的密码校验规则
set global validate_password.policy=LOW;
set global validate_password.length=4;
set global validate_password.mixed_case_count=0;
set global validate_password.number_count=0;
set global validate_password.special_char_count=0;

alter user root@localhost identified by '123456';

#5.远程授权
create user 'root'@'%' identified by '123456';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;

第五步：重启mysql的服务

service mysqld restart