#获取MYSQL8 YUM源;
yum install -y wget
#安装MYSQL8 YUM源;
rpm -ivh mysql80-community-release-el7-1.noarch.rpm
#安装MYSQL8.0软件服务;
sed -i 's#gpgcheck=1#gpgcheck=0#g' /etc/yum.repos.d/mysql-community.repo
yum install mysql-community-server -y
#开机启动MYSQL服务&启动MYSQL服务;
systemctl enable mysqld.service
systemctl restart mysqld.service
#查看MYSQL密码;
grep 'temporary password' /var/log/mysqld.log
#修改密码规则和长度限制;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'aaaAAA111.';
set global validate_password.policy=0;
set global validate_password.length=1;
#修改密码为aaaAAA111.,指令如下;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'aaaAAA111.';
#创建用户&授权jfedu用户访问;
create user jfedu@'%' identified by 'aaaAAA111.';
grant all on *.* to jfedu@'%';
#默认root用户不能远程登录,需要更新密码信息;
update mysql.user set host='%' where user="root";
grant system_user on *.* to 'root';
flush privileges;