centos7安装mysql8

cd /usr/loacl
mkdir mysql 
cd mysql
wget https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm
yum localinstall mysql80-community-release-el7-3.noarch.rpm
##安装的时候会报 源 "MySQL 8.0 Community Server" 的 GPG 密钥已安装，但是不适用于此软件包。请检查源的公钥 URL 是否配置正确。
## 需执行
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
##安装mysql
yum install mysql-community-server -y
##设置开机自启
systemctl enable mysqld
#启动mysql
systemctl start mysqld
##启动后查看初始密码 
grep 'temporary password' /var/log/mysqld.log
#连接mysql
mysql -u root -p
#进去后修改密码等级和长度
SHOW VARIABLES LIKE 'validate_password%';
#等级
set global validate_password.policy=LOW;
#长度 表示四位长度
set global validate_password.length=4   

查看数据库用户

select user,host from mysql.user;

这里的root 仅允许 localhost 访问，下面让 root 允许外网访问：

use mysql;
UPDATE user SET `Host` = '%' WHERE `User` = 'root' LIMIT 1;
flush privileges;
select user,host from user;