Tomcat and MySQL installation configuration summary

The Tomcat and mysql i installed are all uncompressed versions. Installing and configuring Tomcat didn't cost me much time, mostly MySQL, and it almost cost me a day's time.

Tomcat Installation Summary:

First unzip the downloaded Tomcat package onto one of the disks (I put it on the E - Drive).

Then open the command prompt, enter e: , Enter the e - drive, then enter the CD E:\apache-tomcat-8.0.32\bin , enter Tomcat of the bin directory, and then enter Service.bat Install , the carriage return is successfully installed.

：

Configure tomcaton Eclipse :

Open Eclipse Find Window options Click, select Preferences, click.

The following interface appears,

Locate the Server Click, then click Runtime environments, then click the Add button on the right . The following interface appears, find apache Click, select Downloaded installed Tomcat, I chose Apache Tomcat v8.0 (because this is the version I installed).

Click Next, the following screen appears, select the Tomcat installation directory,JRE Select, click Finish.

Click OKand the configuration is complete.

installation configuration for MySQL:

First unzip the downloaded MySQL package into one of the disks (I put it in the E - disk mysql directory).

Before installing, open the mysql-5.7.12-winx64 directory, locate the my-default.ini file, and copy the name My.ini file. Open the my.ini file with Notepad, and change the underlined part of the diagram.

Where basedir e:\mysql\mysql-5.7.12-winx64 mysql unzip the directory. datadir The ellipsis changes to e:\mysql\mysql-5.7.12-winx64\data  mysql 5.7 data directory, first without tube. port Span style= "FONT-FAMILY:CALIBRI;" >3306

：

Configure environment variables (available before or after installation): append E:\MySQL\mysql-5.7.12-winx64\bin to path ;

Then open a command prompt (open as Administrator, otherwise it may be an error), enter e : , enter e -Drive, and enter the CD E:\MySQL\ Mysql-5.7.12-winx64\bin , enter the mysql bin directory, and then enter mysqld -install , the carriage return is installed successfully. :

Then enter mysqld--initialize at the command prompt , enter

then enternet start MySQL, seeMySQLIf the service starts successfully, if it doesn't succeed, seeE:\MySQL\mysql-5.7.12-winx64(unzip the directory) there is noDatafolder, if any, delete, restart the computer, and then enter it againmysqld--initialize, Start againMySQLservice to see if the success, if not successful, willMy.iniin the filePortinstead of the ellipsis in3306. restartMySQLService, if not successful, ask the degree Niang, otherwise re-loaded againMySQL, and then follow the steps to do it again.

Connection database:mysql-u root-p Enter

The first connection database password is E:\MySQL\mysql-5.7.12-winx64\data( within the Data folder of theextracted directory ). Desktop-fkgfd5h.err file, note that desktop-fkgfd5h is the computer name, different computers, as long as you find the . Err File on the line, Notepad open, find A temporary password is generated for [email protected]:) jPy) by/j6d& This line: The temporary password is followed. My temporary password is jPy) by/j6d&.

The database connection was successful when the password was entered.

Change Password:

Stop the MySQL service First,

Then enter Mysqld_safe--skip-grant-tables (first modified)

Open a command prompt, start the MySQL service, enter mysql-u root-p return, display Enter password do not lose the password, Direct Enter,

Input:

Update Mysql.user set Authentication_string=password (' new password ') where user= ' root ' and host= ' root ' or host= ' localhost '; (you can do this directly with this statement later) enter

Input flush privileges; Enter

Enter quit; Enter

The password modification was successful.

Restart the MySQL Service Connection database with the new password.

Note : the Password field is not already in the user table in the new mysql database , and is changed to authentication_string

Tomcat and MySQL installation configuration summary