Tomcat web 站点部署 （jspgou）

Tomcat 部署web站点（jspgou）

部署前需要配置tomcat以及jdk环境

1. 首先部署mysql数据库

[root@localhost ~]# wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
[root@localhost ~]# rpm -ivh mysql80-community-release-el7-3.noarch.rpm
# 选择mysql版本
[root@localhost ~]# vim /etc/yum.repo.d/mysql-community.repo
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/7/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
# 安装mysql
[root@localhost ~]# yum -y install mysql-server mysql
[root@localhost ~]# systemctl start mysqld
[root@localhost ~]# systemctl enbale mysqld
[root@localhost ~]# grep pass /var/log/mysqld.log  #过滤出mysql临时密码
2021-05-24T12:17:12.634473Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: xo0tuRfDdw+O
# 修改数据库密码
[root@localhost ~]# mysqladmin -uroot -p'xo0tuRfDdw+O' password 'Tomcat@123'
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
[root@localhost ~]# mysql -uroot -p'Tomcat@123'
mysql> create database jspgou;
Query OK, 1 row affected (0.00 sec)
# 创建用户并授权
mysql> create user 'tomcat'@localhost identified by 'Tomcat@123';
Query OK, 0 rows affected (0.01 sec)
mysql> grant all on jspgou.* to tomcat@localhost;
Query OK, 0 rows affected (0.02 sec)

2. 上线gspgou商城

[root@localhost ~]# unzip jspgouV6.1-ROOT.zip
[root@localhost ~]# rm -rf /usr/local/tomcat/webapps/*
[root@localhost ~]# cp -r /root/ROOT /usr/local/tomcat/webapps/
# 配置mysql驱动并导入sql文件
[root@localhost ~]# vim /usr/local/tomcat/webapps/ROOT/WEB-INF/config/jdbc.properties 
#mysql\u914d\u7f6e 
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/jspgou?characterEncoding=UTF-8
jdbc.username=tomcat
jdbc.password=Tomcat@123
hibernate.db=mysql
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
# 添加sql_mod
[root@localhost ~]# im /etc/my.cnf 
sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUB
explicit_defaults_for_timestamp=1
[root@localhost ~]# systemctl restart mysqld
[root@localhost ~]# mysql -uroot -p'Tomcat@123' -D jspgou < jspgou.sql
[root@localhost ~]# /usr/local/tomcat/bin/startup.sh

成功访问
localhost:8080

nlnlznl