阿里云配置总结

springboot项目部署（filezilla，putty）

1.jdk安装(略)

yum search java|grep jdk
yum -y install java-1.8.0-openjdk*

2.mysql安装

yum  list installed mysql*     检查是否安装数据库
yum list installed | grep mysql
systemctl enable mysqld.service 开机启动
systemctl list-unit-files | grep mysqld 查看开机启动是否有效
grep 'temporary password' /var/log/mysqld.log  查看初始密码
mysql -u root -p 登陆

设置密码
set global validate_password_policy=LOW
set global validate_password_length=6
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 配置远程登录
flush privileges; 立即生效

systemctl start mysqld.service； 开启服务，可略
systemctl status firewalld；

这个

1.wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
2.yum -y install wget
3.yum -y install mysql57-community-release-el7-8.noarch.rpm
 不用这个yum localinstall mysql57-community-release-el7-11.noarch.rpm
 不用这个yum repolist enabled | grep "mysql.*-community.*” 出现三条mysql 源安装成功
4.yum install mysql-community-server 安装mysql服务
5.systemctl status mysqld service 开启服务 /查看服务systemctl status firewalld；
6.设置密码
set global validate_password_policy=LOW
set global validate_password_length=6
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 配置远程登录
flush privileges; 立即生效

以上配置完成 在Navicat Premium 中连接阿里云数据库，然后将库表建立，配置项目配置文件
数据库名-密-url：刚在阿里云配置的数据库

spring:
  thymeleaf:
    cache: false
    encoding: UTF-8
    content-type: text/html
    mode: HTML5
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://47.96.145.30:3306/lfpay
    driver-class-name: com.mysql.jdbc.Driver
mybatis:
  mapper-locations: classpath:mapper/*Mapper.xml
server:
  port: 80

3.项目打包

maven - package 打成jar包

4.配置阿里云入出口规则

配置mysql：3306端口号
以及项目配置文件中访问端口号

5.域名解析