Tomcat网站部署与数据库链接

一.部署数据库
1.下载数据库mysql

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
rpm -ivh mysql80-community-release-el7-3.noarch.rpm
cd /etc/yum.repos.d/
vim mysql-community.repo
注意enabled中0表示关闭，1表示开启

安装

yum -y install mysql-server mysql
systemctl start mysqld  启动mysql
systemctl enable mysqld  开机自启
grep pass /var/log/mysqld.log  查看默认密码
mysqladmin -u root -p'%6yx817IeX-J' password 'Wangxiaoba@123' #修改密码
mysql -uroot -p'Wangxiaoba@123'  #登录数据库

配置数据库

mysql> create database jspgou default charset=utf8;  #创建数据库设置字符集
grant all on *.* to root@'%' identified by 'Wangxiaoba@123'; #给帐户授权

2.配置应用

上传应用代码
unzip jspgouV6.1-ROOT.zip     #解压包
mkdir     /data/application/tomcat/webapps/
cp -r ROOT/ /data/application/tomcat/webapps/
vim ROOT/WEB-INF/config/jdbc.properties    #修改配置文件

3.配置数据库连接----jdbc

将数据导入数据库:
[root@java-tomcat1 ~]# cd DB/
[root@java-tomcat1 DB]# ls
jspgou.sql
[root@java-tomcat1 DB]# mysql -uroot -p'QianFeng@123' -D jspgou < jspgou.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1067 (42000) at line 97: Unknown error 1067
[root@java-tomcat1 DB]# vim /etc/my.cnf    ----添加sql_mod
sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUB
explicit_defaults_for_timestamp=1
[root@java-tomcat1 DB]# systemctl restart mysqld
[root@java-tomcat1 DB]# mysql -uroot -p'QianFeng@123' -D jspgou < jspgou.sql
启动tomcat访问:
[root@java-tomcat1 ~]# /data/application/tomcat/bin/startup.sh
[root@java-tomcat1 ~]# netstat -lntp

4.访问ip