在线安装mysql
1)下载rpm文件
yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
2)安装Mysql数据库
yum install mysql-community-server -y
3)查看mysql密码
grep ‘temporary password’ /var/log/mysqld.log
4)修改root密码
alter user user() identified by ‘Abc123456.’;
5)允许mysql远程链接
update user set host = ‘%’ where user=‘root’;
flush privileges;
修改my.cnf
character_set_server = utf8
bind-address=0.0.0.0
6)开启防火墙策略—3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload