YUM方式MYSQL安装5.7.x或者8.0.x

准备工作

# 查看安装mysql版本
rpm -qa|grep mysql;
# 依次卸载
yum remove xxx;

获取yum源

wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
或者：
wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

安装mysql的yum源

yum -y install mysql57-community-release-el7-11.noarch.rpm
或者：
yum -y install mysql80-community-release-el8-1.noarch.rpm

yum方式安装mysql(不校验签名)

yum -y install mysql-server --nogpgcheck

启动mysql

systemctl start mysqld.service
systemctl status mysql.service

进入mysql，获取临时密码

cat /var/log/mysqld.log| grep password

修改用户密码

ALTER USER USER() IDENTIFIED BY 'root@12#';

授权远程访问

grant all privileges on *.* to 'root'@'%' identified by 'root@12#' with grant option;
flush privileges;

设置密码策略

set global validate_password_policy=0;
set global validate_password_length=1;