centos8 安装MySQL8.0

1.下载mysql的repo源

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

2.安装数据源

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

3.检查数据源

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

4.禁用CentOS8自带的mysql模块

yum module disable mysql

5.安装数据库

yum install mysql-community-server

6.启动MySQL

service mysqld start

7.展示MySQL的随机密码

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

8.登录MySQL并且修改MySQL的密码

mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Admin@123';

9.查看密码策略

SHOW VARIABLES LIKE 'validate_password%';

10.设置密码策略

修改密码长度：set global validate_password.length=1;（长度）
修改密码等级：set global validate_password.policy=0;（等级）

11.涉及简单的密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

12.创建一个远程访问的root用户，并且赋予密码root123

create user 'root'@'%' identified by 'root123';

13.为这个账号授权

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