centos8 安装mysql8

第一步，下载安装包并安装

wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

yum install mysql80-community-release-el8-1.noarch.rpm

第二步，检查数据源，禁用系统自带模块

yum repolist enabled | grep "mysql.*-community.*"

yum module disable mysql

第三步，在线安装mysql主体

yum install mysql-community-server --nogpgcheck

第四步，启动mysql服务并用临时密码登录

systemctl start mysqld.service

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

mysql -u root -p  # 输入上一行找到的临时密码

第五步，修改为自定义密码。重置密码策略（可选）

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Nfs_China@123';

set global validate_password.length=4;

set global validate_password.policy=0;

set global validate_password.check_user_name = 0;

第六步，设置mysql可以远程连接

create user 'root'@'%' identified by 'Nfs_China@123';

grant all privileges on *.* to 'root'@'%' with grant option;

FLUSH PRIVILEGES;