mysql 5.7. 17 winx 64 Installation Free Configuration Tutorial

Recent experience in installing mysql 5.7. 17 installation-free version

1. Download and unzip

https://pan.baidu.com/s/1mi4UHtA

2. Set environment variables

path:

3. Configuration files

Copy my-default, paste it in the root directory and rename it my

my Profile Internal

Mainly modify basedir, datadir and port
Note: data is self-generated and does not need to be created.

4. Command Prompt Action (DOC) Note: Must be an administrator

1. Initialize

mysqld --initialize --user=mysql --console
Note: The initialization will appear at this time. The random password (localhost) 1 must be remembered
2016-05-08T02:58:53.791057Z 1 [Note] A temporary password is generated for root@
localhost: UiS < C(.i(0yg

2. Installation

Then you will be prompted:
Service successfully installed.

3. Start service
Turn on net start MySQL
Success will be prompted
service was started successfully.

4. Change your password

5. Enter the previous random password

6. Then enter the password modification statement

set password for root @ localhost = password ('New Password');

7. Stop service
net stop mysql
You can do it here