Some details about uploading a web project to a server and connecting to a database

Recently, I encountered a lot of trouble uploading a web project to the server. 1. Right-click the project package of the web project in myeclipse and select Export... (export), click Next, Click Browse, and select the export location, and then click Finish. 2. the server Connection Tool putty first downloads the toolkit I currently

Recently, I encountered a lot of trouble uploading a web project to the server. 1. Right-click the project package of the web project in myeclipse and select Export... (export), click Next, Click Browse, and select the export location, and then click Finish. 2. the server Connection Tool putty first downloads the toolkit I currently

Recently, I encountered a lot of trouble uploading a web project to the server.

1. web project Packaging

Right-click the myeclipse project and chooseExport...(Export), and then select

Click Next

Click Browse to select the export location, and then

Click Finish.

2. putty, a server Connection Tool

First download the Toolkit

Currently, I only use two of the tools putty.exeand psftp.exe. The following describes the usage in sequence.

1.1putty.exe

Double-click it or use the command line to open it ,:

Enter the IP address of the server to be connected:

Keep others by default. Click Open to bring up the command line:

Enter the account and password to log on to the server.

1.2psftp.exe

This is mainly used to upload files to the server and open them using the command line.

Connection Server:

Command Format: open Administrator Account @ Server IP address. Then press enter to enter the Administrator Password

The above indicates that the connection has been completed. Next, upload the file to the server in the format of: put file path to be uploaded:

Enter the server's user directory "~ "Bottom.

3. Grant mysql Database User Permissions

In centos, it is a little difficult to access the database using web projects, and it is always unable to connect to the database.

When I use the yzs_feedbackSystem project to obtain the test database using JDBC, the account and password are correct but cannot be obtained. Therefore, I think it may be a permission issue. My solution is as follows: create a mysql user and grant the database test permission (only the database) to it. Then, JDBC uses it to access the database. The result proves that the database is successful!

First, create an empty database with the Administrator:

Mysql> create database yzs_feedbackSystem;

Exit the Administrator and import the yzs_feedbackSystem. SQL file:

Mysql-usimon-p yzs_feedbackSystem <yzs_feedbackSystem. SQL;

In this way, the data is imported.

Then we create a user named simon with a password of 123.

First, you have to use the super administrator to log on to mysql and then execute:

Mysql> create user simon @ 'localhost' identified by "123 ";

Then, grant the database test operation permission to it:

Mysql> grant all on test. * TO simon identified by "123 ";

In this way, you can write the user name and password in jdbc of the yzs_feedbackSystem project to operate the database.

4. Some command lines for linux (centos release) currently used:

Ls: list the contents of the current directory

Cd ..: return to the previous directory

Cd ~ : Return to the user directory

Pwd: displays the current directory path

Rm-rf file/dir: directly delete the file or directory dir

Jar-vxf *. jar/*. war: Decompress the jar package or war package.

Target mv source file: Move (CUT)

There is a catalina. out file in the tomcat/logs directory. Execute: tail-f catalina. out to dynamically display tomcat log Content