安装mysql数据库:
1.下载mysql源安装包: wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
2.安装mysql源:yum localinstall mysql57-community-release-el7-8.noarch.rpm
若结尾出现complete!,则说明MySQL源安装完成
3.检测是否安装完成:yum repolist enabled | grep "mysql.*-community.*"
4.安装mysql:yum install mysql-community-server
若结尾出现Complete!, 则MySQL安装完成
5.设置开启启动mysql服务:systemctl enable mysqld
6.查看安装的mysql版本:rpm -aq | grep -i mysql
7.启动MySQL服务:systemctl restart mysqld
8.查看MySQL初始密码:grep 'A temporary password' /var/log/mysqld.log
9.登录mysql:mysql -uroot -p 输入默认密码
10.这是操作会报错,提示修改密码,且密码要设置复杂点符合策略
修改密码:set password=password('密码');
11.设置用户能够远程访问mysql:
grant all privileges on *.* to '用户名'@'ip地址' identified by '密码' with grant option;
若需要用户在任何ip地址都能远程访问,则将上面的ip地址用%替换即可
13,授权立刻生效:fluse privileges;
12.注:mysql结束都要有分号;结尾,登录mysql后,命令不要复制,手打,不然不能执行
然后开放阿里云服务器安全组的3306端口即可