0. Before installation must read
Mysql as green package after 5.7.20 version version of decompression have no my ini or my - default. Ini configuration file, the need to add configuration,
No data folder database, the data folder can't own new, need to order the initialize initialization,
My - default. The ini file does not exist is not important, the key to himself in the root directory. Create a new my ini file
Installation environment:
Win10-64
Mysql - 5.7.23 - winx64.zip (mysql green extract)

1. Extract the zip package to specified directory, for example, D: \ tools \ mysql - 5.7.23 - winx64
Note: not in the C drive, win10 system permissions not complains, trouble

2. In D: \ tools \ mysql - 5.7.23 - winx64 directory to create my. Ini file (tutorial has provided), and add the relevant configuration
Note 1: my ini configuration file inside the annotation statements don't have a "" double quotes
Note 2: the basedir and datadir is modified to corresponding directory
Note 3: in my ini in the correct path needs to be double slash "\ " datadir=D: \ \ tools \ \ mysql - 5.7.23 - winx64 \ \ data

3. Please do not create your own data folder, which can cause service cannot be started, automatically generated by the mysql data, specific steps are as follows: 1. Open the CMD command window in the form of the administrator (do not open the CMD running directly, may be an error), and into the mysql installation directory under the bin directory,
CD D: \ tools \ mysql - 5.7.23 - winx64 \ bin
2. Install mysqld install
Note 1: the following command to remove the mysql service mysqld remove swVo# lXoR2 (BK? YWUjFrH08 & amp;
3. Initialization mysqld - the initialize the console note 1: add - the console parameter initialization is complete, will be in the final print out a temporary password console, useful to copy down for a while, the sample is as follows:
A temporary password generated for root @ localhost: & gt; Qp<? KplB59b

4. The start/stop (also can start or stop) in Windows service net start mysql
Net stop mysql4.
Console command way on mysql
Mysql - 3306 - u P root -p
Temporary password input before

5. Change passwords
SET the PASSWORD=PASSWORD (" 123 "); (below used to 5.7 or 5.7)
The ALTER user 'root' @ 'localhost' IDENTIFIED BY 'password'. (for more than 5.7)