阿里云搭建项目布署环境

重置系统（非必须）

1. 停止系统
2.  

搭建环境

1. JDK

https://www.oracle.com/technetwork/java/javase/downloads/jdk13-downloads-5672538.html

1. Tomcat

https://tomcat.apache.org/download-90.cgi

1. Mysql

https://dev.mysql.com/downloads/repo/yum/

这里是repo源，通过centos自带的yum安装

1. redis

https://redis.io/

 

 

安装JDK

rpm -ivh jdk-13.0.2_linux-x64_bin.rpm

安装Mysql

1. 安装用来配置mysql的yum源的rpm包

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

1. 安装mysql

yum install mysql-community-server

 

 

 

1. 开启mysql服务

service mysqld start

mysql安装成功后创建的超级用户“root@localhost”的密码会被存储仔/var/log/mysqld.log中,可以使用如下命令查看密码

grep 'temporary password' /var/log/mysqld.log

使用root用户和临时密码登录数据库,用如下命令修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

问题1: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

解决:密码输错了

问题2: ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

解决:ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; 注意单引号

问题3: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

密码由8位组成,必须包括大小写字母,数字,特殊字符,如’NRd94**’

 

SHOW VARIABLES LIKE ‘validate_password%’;

set global validate_password.policy=LOW;

set global validate_password.length=8;不能少于6

set global validate_password.mixed_case_count=4;

set global validate_password.number_count=0;

set global validate_password.special_char_count=0;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'rootroot';

1. 开启远程连接

通过阿里云控制台开放3306端口

 

 

1. 配置一个支持远程登录的账号

GRANT SELECT,  UPDATE,   INSERT,   DELETE ON *.* TO 'work'@'%' identified by 'rootroot';

问题1: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'rootroot''

原因:新版的mysql将创建账户和赋予权限的方式分开了

解决:

创建账户:create user ‘work’@’%’ identified by ‘rootroot’;

赋予权限: GRANT SELECT,  UPDATE,       INSERT,   DELETE ON *.* TO 'work'@'%';

grant all privileges on *.* to root@"xxx.xxx.xxx.xxx" identified by "密码";

flush privileges;

本地登录: mysql -uwork -P3306 -h 123.57.75.143 –p

update user set host='%' where user = 'root';

问题1:SQLyog连接mysql8.0时报错：错误号码2058

解决: ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码.';

 

 

 

安装redis

tar -zxvf redis-5.0.7.tar.gz

vim redis-5.0.7/redis.conf

安装:

启动redis服务:

src/redis-server redis.conf

连接测试:

安装tomcat

tar -zxvf apache-tomcat-9.0.30.tar.gz

启动:

./apache-tomcat-9.0.30/bin/startup.sh

发布项目

vi apache-tomcat-9.0.30/conf/server.xml

重启:

./apache-tomcat-9.0.30/bin/shutdown.sh

./apache-tomcat-9.0.30/bin/startup.sh

 

 

 

 

 

 

 

 

Mysql常用命令

1. 查看端口号:

show global variables like 'port';

问题1:tomcat启动,访问不了首页

解决:

linux常用命令

1. 删除文件rm -rf apache-tomcat-9.0.30
2.