MySql8.x安装

1.wegt下载mysql8.x源或上传rpm包到master节点
wget -P /opt https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

1.2 加载本地yum源 
yum localinstall -y /opt/mysql80-community-release-el7-3.noarch.rpm

1.3 yum search mysql
查询是否存在 mysql-community-server.x86_64
yum install -y mysql-community-server.x86_64 --nogpgcheck 下载mysql服务
service mysqld start 开启mysql服务

2.mysql 密码设置
2.1 查询mysql初始密码
cat /var/log/mysqld.log |grep password

2.2 使用初始密码登录
mysql -u root -p

由于修改密码规则需经过密码重置，因此基于初始密码做简单修改，如在末尾增加一个a
alter user 'root'@'localhost' identified by '初始密码+a';

2.3 修改8.0密码规则
set global validate_password.policy=LOW;
set global validate_password.length=6;

2.4 设置自定义密码
alter user 'root'@'localhost' identified by '123456';

3. 赋予外部连接权限
create user 'root'@'%' identified by '123456';
grant all privileges on *.* to 'root'@'%' with grant option;

刷新系统权限相关表
flush privileges;