centos7yum安装mysql8

1.下载MySQL的repo源
wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

2、安装MySQL源
rpm -Uvh mysql80-community-release-el7-1.noarch.rpm

3、安装公钥
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

4、使用yum安装
yum install -y mysql-community-server

启动mysql
systemctl start mysqld

获取mysql的临时密码
grep “password” /var/log/mysqld.log

先重置mysql密码
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘MyNewPass4!’;
否则会报错如下
1819 (HY000): Your password does not satisfy the current policy requirements

查看MySQL密码设置
SHOW VARIABLES LIKE ‘validate_password%’;
降低免密安全性设置
set global validate_password.length=1;
set global validate_password.policy=0;
关闭用户名校验，否则密码不能被设置为root
set global validate_password.check_user_name=‘OFF’;
修改root密码
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘root’;

创建远程访问用户
CREATE USER ‘root’@‘%’ IDENTIFIED BY ‘root’;
ALTER USER ‘root’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘root’;
GRANT ALL ON . TO ‘root’@‘%’;
flush privileges;

开启防护墙端口
firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload