MySQL5.7 installation process and parameters and setup instructions

Recently in the MySQL class, in order to save trouble in the MySQL5.5 version. Because WIN10 can run MySQL32 bits either 32 or 64. There are a lot of users know MySQL official website, to download the latest version of MySQL to use, I do not object, but the problem is to install a bunch of things at once. We just need a MySQL database, and everything else is not needed. So find time to write an installation tutorial on the latest version of MySQL.

　　Preparatory work

1, MySQL installation files one (such as, Mysql-installer-community-5.7.10.0.msi) 2, paper notebook one (easy to record parameters and key steps, after all, this life will not be used only once) 3, WIN10 security settings ( WIN10 security mechanisms are stricter, setup-Update and security-for developers-select developer mode

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/b71eff93ef6e4b2bb173e450e3b6cbaa.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

　　installation process

Double-click the downloaded. msi format of the MySQL installation file to install it. After double-click, the following installation interface appears;

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/a972111de06642979d2cfd6cd543dc45.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

This interface is installed after the MySQL installation file is completed, the File Installation Welcome screen appears, these several options, click "Install MySQL Products" on the line. (The first one is to install the product, the second and third is the description and help)

After clicking, the following screen appears:

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/f57107c9dd30476b8f56d94c26da5c28.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

I receive the license terms (I accept the license terms) in front of the tick, and then click "Next" (next)

This is to ask us to check whether there is a new version before installation, here we choose to skip it, if you feel it is necessary to check the new version;

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/c9e03184b2fc45ca9e45670b14628f03.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

Tick the skip ths check for updates (not recommended) (Skip this check update (not recommended)) and click "Next" (next)

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/08d3d1af96f24cff9ea5f0a0e3713d2d.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

　　Description Section :

Choose the type of installation here: Developer default: Developer type, which is the choice of the server Onle for the programmer: Just install the type client Onle: Just install as client type full: Install all custom: User-defined installation (if you are familiar with this option)

Here I choose Developer Default (Developer type).

In Installation path (installation path) Select the path where we put the MySQL installation location, I choose under D Drive.

In the data path, select the location where the data is placed, and I choose under the D disk.

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/7a4282cc04f94b639af62c5911a35401.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

Select OK and click Next (Next)

Note: Select the data path path when the data is not added, the program will automatically add, if you add data here, and so on, and so on, to the directory to view, in this directory more data directory

To check and install MySQL and the required plugins, click Next Next

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/c6e426bc63a0492e9c3752f9af655a1c.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

The installation progress of the interface to us prompted the following program is going to be updated or is installed, click Execute execution to install

You can click the "Show Details" button to see the installation details.

After the installation is complete, you will be prompted to configure what to do, click Next to configure the settings

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/08ff44bb11b049c288f7ef787219b73b.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

Then came the interface to configure MySQL;

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/c106b298d19b4089b342ff103c8903a0.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

Config type in server configuration type (server config types) I choose development machine

(Developer Machine (development machines) server machine (server) dedicated MySQL server machine (dedicated MySQL servers))

Tick the Enable TCP/IP networking (TCP/IP network enabled) and fill in port number 3306 (the program already defaults, if there is no default handwriting), the industry 3306 is the default port for MySQL. It is important to check the open Firewall port for network access before opening the firewall port, and if you do not choose, access to this port may be intercepted.

Tick the show advanced options under Advanced Configuration (Show premium option)

Then click Next Next

The account is default to root and I need to set the password.

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/d609804da10e49c997e9932556061537.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

MySQL Root Password: Enter a new MySQL password

Repeat Password: Enter the password again;

After you fill it out, click Next Next.

Here you are asked about the configuration of the service name after the MySQL service is started

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/f252c2233e984dd6bc246858ddab583b.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

> In Windows Service name under Windows Service details, give MySQl a service name, let it default on the line, if it has been installed before, please name the idea. > A tick in front of start start MySQL server at System startup (startup MySQL servers) to enable MySQL to start with Windows, if you do not want MySQL to start with Windows To not tick. > Under Run Windows Service as, select the standard system account (current system accounts support) and click Next.

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/6aaf16ddac014264ac4d86d5a188859b.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

This is the logging setting, everything makes it default, click Next

If you do not save the log, you should not select the advanced configuration in the server configuration.

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/4c65036d18fd455592a69782ca1387e0.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

The program starts the configuration modification installation save operation, on the next few pages click Next directly

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/9a1c7756e6114accbd1ac532c3e0cb71.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

When the program installation configuration is complete, you will be prompted to say that the program has been installed, install the finished interface in the start MySQL Workbench after Setup (start the MySQL Workbench after Setup is complete)

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/702bf38d5911449c9edae1d52facffa8.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

Click Finish below to end the installation of MySQL. This completes the MySQL installation.

Use DOS to connect MySQL, enter mysql-u user name-p password

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/f095d2c4986448d6ba0e50ed88d83677.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

Use the tool interface as follows

650) this.width=650; "src=" Http://img.mp.itc.cn/upload/20160606/0169d51123bf43e29b033676f3201e41.jpg "style=" border:0px;margin:0px;padding:0px;font-size:0px; "/>

　　Precautions

1, set the MySQL password must remember, in the future database connection will be used frequently. 2, MySQL Windows service and let it start manually, each time, to start. Otherwise, the boot will start, when not in use, still running memory.

This article is from the "11247808" blog, please be sure to keep this source http://11257808.blog.51cto.com/11247808/1788929

MySQL5.7 installation process and parameters and setup instructions