(一) centos-7安装mysql-8

查找mariadb

rpm -qa | grep mariadb

卸载mariadb

sudo rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps

下载 mysql.rpm

wget https://repo.mysql.com//mysql80-community-release-el7-7.noarch.rpm

安装rpm

yum install -y mysql80-community-release-el7-7.noarch.rpm

查看一下安装效果

yum repolist enabled | grep mysql.*

mysql80-community/x86_64                MySQL 8.0 Community Server           346

安装 mysql-community-server

yum -y install mysql-community-server

启动MySQL服务

systemctl start  mysqld.service
查看一下运行状态 
systemctl status mysqld.service

关闭防火墙(慎重)

systemctl stop firewalld.service
systemctl disable firewalld.service

查看mysql自动生成密码

grep "password" /var/log/mysqld.log

登录mysql

mysql -uroot -p

初次登录，修改密码，

默认规则 大小字母，小写字母，特殊字符，8位
alter user user() identified by "123456Aa#";

修改root账号可远程登录

use mysql;
update user set host = '%' where user = 'root'; 
select host, user from user; 
授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
刷新
FLUSH PRIVILEGES; 

设置自动启动

systemctl enable mysqld
systemctl daemon-reload

修改mysql密码策略

SHOW VARIABLES LIKE 'validate_password%'; 

设置密码验证强度
set global validate_password.policy=LOW;

设置密码长度
set global validate_password.length=4;


alter user user() identified by "123456";