centos8安装mysql 5.7

1. 添加MySQL存储库

禁用MySQL默认的AppStream存储库：

sudo dnf remove @mysql
sudo dnf module reset mysql && sudo dnf module disable mysql

安装mysql的rpm源

wget http://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

安装mysql的rmp

rpm -ivh mysql80-community-release-el7-3.noarch.rpm

查看将要安装的mysql相关文件

yum repolist all | grep mysql

默认情况下mysql80-community是启用的，mysql57-community是禁用的，用以下命令改变将要安装的版本

yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community

安装MySql

yum -y install mysql-community-server
或
yum install mysql-community-server --nogpgcheck  

mysql --version
systemctl start mysqld

修改密码

mysql -uroot -p
ALTER USER USER() IDENTIFIED BY 'root';
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456..' PASSWORD EXPIRE NEVER;
flush privileges;

设置远程访问

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

设置防火墙

iptables -I INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
iptables -L -n