Install the Jdk,tomcat and MySQL and visualizer navicat and install the Tomcat,mysql service in the Windows environment to let it start, the first time to set the MySQL root password and forget the password when the modification method, pro-Test useful

1. Install jdk

(1) Download jdk8, win64 version

: Http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

(2) Click the downloaded exe file to install

Select the jdk installation location, I choose F: \ environment \ java \ jdk.

Select the jre installation location, I choose F: \ environment \ java \ jre.

Wait for the installation to complete, click Close.

(3) Configure environment variables

Open the control panel, click Advanced System Settings, and click Environment Variables.

Click New under System Variables and fill in the corresponding values

JAVA_HOME F: \ environment \ java \ jdk

CLASSPATH% JAVA_HOME% \ lib;% JAVA_HOME% \ lib \ tools.jar;

 


 


 

Edit the Path variable, not new, fill in% JAVA_HOME% \ bin; Note that if there is no; (semicolon) before the original Path, it should be added;% JAVA_HOME% \ bin;

(4) Verify whether the installation and configuration is successful

Enter cmd to enter the console, enter javac, a message appears, that is, success O (∩_∩) O haha ~

 

3 install mysql
(1) Download the MYSQL5.6-win64 version (must be 5.6.xx, and the following configuration is not applicable)
: Http://downloads.mysql.com/archives/community/

(2) Decompress the compressed package

Unzip the downloaded MySQL compressed package to a custom directory, my decompression directory is:
F: \ environment

(3) Make a copy of the default file my-default.ini in the unzipped directory and rename it my.ini

Copy the following configuration information to my.ini and save it. Among them, the unzip directory filled by basedir, and the data directory under #decompress directory filled in by datadir.

################################################ #######
[client]
port = 3306
default-character-set = utf8

[mysqld]
port = 3306

character_set_server = utf8
# character_set_server = utf8 must be written like this;

basedir = F: \ environment \ mysql-5.6.28-winx64
#Unzip the directory

datadir = F: \ environment \ mysql-5.6.28-winx64 \ data
#Unzip the data directory under the directory, which must be the data directory

sql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

################################################ #######

(4) Configure environment variables
Add under the path environment variable: F: \ environment \ mysql-5.6.28-winx64 \ bin

(5) Register windows system service
Register mysql as a windows system service

From the console, enter the bin directory under the MySQL decompression directory (open as an administrator when opening cmd):



Enter the service installation command: mysqld install MySQL --defaults-file = "F: \ environment \ mysql-5.6.28-winx64 \ my.ini"

 

After successful installation, it will prompt that the service installation is successful. In the window service management, set mysql to start automatically.

(6) Modify the password of the mysql root user

A: Just after installing mysql, root is a blank password. Enter the console as a direct administrator and enter net start mysql to start mysql.

Then enter the following sentence, press enter for each sentence.

mysql –u root;


use mysql;

update user set password = PASSWORD (‘112358‘) where user = ‘root’;

flush privileges;

exit;

Add the password to complete, test and verify, enter: mysql –uroot –p112358;

The password is added successfully.

B: If you forget the root password, first net stop mysql to close mysql.

Open another cmd (administrator identity), first enter the bin directory, enter mysqld --skip-grant-tables, start mysql, then open another cmd, enter

mysql
mysql> use mysql;
mysql> update user set password = password ("root") where user = "root";
mysql> flush privileges;
exit

You're done [] ~ (￣ ▽ ￣) ~ *

(7) Install mysql visualization tool

Download and install Navicat for MySQL (This software is installed like normal application software, click Next to do it)

Address: http://www.xitongzhijia.net/soft/24296.html#comment

After the installation is successful, click the connection on the upper left, enter the password of the mysql root user in the new connection dialog box, and click OK.

After confirming, a new connection will appear. Right-click to open the connection and display the database that mysql comes with.

 

 

 

     3 Install tomcat (1) Download tomcat7 or above, win64
      Address: http://tomcat.apache.org/download-80.cgi

          After downloading and unzipping, my directory is F: \ environment

         (2) Configure environment variables
         Click on the environment variable under the system variable to create a new input

TOMCAT_HOME F: \ environment \ apache-tomcat-8.0.33

Modify the system variable CLASSPATH, add% TOMCAT_HOME% \ bin


After confirming, click startup.bat in the bin file in the installation directory. The console displays the server startup time


Enter localhost: 8080 in the browser. If it appears, the tomcat installation was successful. Click shutdown.bat in the bin folder to shut down the tomcat server.

 (3) Installation service
Enter the bin file in the tomcat installation directory as an administrator, enter the command service.bat install,

There will be a prompt if the installation is successful.
Select Apache Tomcat 8.0 Tomcat8 in the service, right-click, select properties, select the startup type as automatic startup, and confirm. In this way, tomcat can automatically restart when the server computer restarts.


I succeeded according to my method. Anyway, I would recommend Wow <(＾ － ＾)> <(＾ － ＾)>

In windows environment, install jdk, tomcat and mysql and visual tool Navicat and install tomcat, mysql service to let it start automatically, the first time to set the mysql root password and the modification method when you forget the password, it is useful to test