centos7以rpm的方式安装mysql8

1. 卸载原来的mysql环境

#列出已安装的mysql
rpm -qa|grep mysql
rpm -ev
#卸载原来的mariadb环境
rpm -qa|grep mariadb
rpm -ev 

2. 下载mysql8的rpm

wget http://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm

3. 安装依赖

sudo rpm -ivh mysql80-community-release-el7-1.noarch.rpm

4. 安装

yum install mysql-server
#如果报错 没有公钥 导入公钥
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
#再安装
yum install mysql-server

5. 初始化mysql

mysqld --initialize

6. 查看临时密码

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

7. 启动mysql

systemctl start mysqld.service

8. 登陆mysql

mysql -u root -p 
#回车 输入临时密码

9. 修改密码

alter user 'root'@'localhost' identified by '123456';
#如果报错 密码太简单不符合规则
set global validate_password.policy=0;
#再修改

10. 开启远程连接

 use mysql;
 #修改root账户权限
 update user set host = '%' where user = 'root';
 #刷新权限
 flush privileges;