阿里云主机在线安装mysql数据库

1.wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2.yum -y install mysql57-community-release-el7-10.noarch.rpm
3.yum -y install mysql-community-server
4.systemctl start mysqld.service
5.查看状态systemctl status mysqld.service
6.开机启动systemctl enable mysqld
刷新systemctl daemon-reload
7.查看临时密码grep "password" /var/log/mysqld.log
8.登录mysql -u root -p临时密码
9.set global validate_password_policy=0;
10.set global validate_password_length=1;
11.修改密码alter user 'root'@'localhost' identified by '新密码';

　　修改登录用户 update user set host='%' where user='root';

12.打开防火墙systemctl start firewalld

13.查看状态systemctl status firewalld

14.开放3306  firewall-cmd --zone=public --add-port=3306/tcp --permanent;

15.打开阿里云主机控制台，打开安全组规则-配置规则配置端口开放