Mysql-5.7.11-winx64.zip installation Configuration

1. Download

http://cdn.mysql.com//downloads/mysql-5.7/mysql-5.7.11-winx64.zip

2. Unzip the ZIP package;

D:\Program files\mysql-5.7. -winx64

3. Configure environment variables,

3.1 Add path Path,

D:\Program files\mysql-5.7. -winx64\bin

3.2. Modify the Mysql-default.ini configuration file,

Original

Set Set  as ==== .....

Switch

Set Set  as  = D:\Program files\mysql-5.7. One-= D:\Program files\mysql-5.7. One-3306= .....

4. Enter command prompt cmd as Administrator

Into the MySQL bin directory,

Microsoft Windows [version 6.3.9600] (c) Microsoft Corporation. All rights reserved. C:\USERS\ADMINISTRATOR>CD D:D:C:\USERS\ADMINISTRATOR>CD D:\Program files\mysql-5.7.11-winx64\binc:\users\ Administrator>d:d:\program files\mysql-5.7.11-winx64\bin>

Execute the mysqld.exe--initialize command,

D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe--initialized:\program files\mysql-5.7.11-winx64\bin>

The data directory was created

5. Execute Mysqld-install command

D:\Program Files\mysql-5.7.11-winx64\bin>mysqld-installservice successfully installed.  Successful Installation Services

6. Execution of Mysqld.exe-nt--skip-grant-tables

Note: The window does not respond

1Microsoft Windows [version6.3.9600]2(c) -Microsoft Corporation. All rights reserved. 3 4C:\users\administrator>CD D:5 D:6 7C:\USERS\ADMINISTRATOR>CD D:\Program files\mysql-5.7. One-Winx64\bin8 9C:\users\administrator>D:Ten  OneD:\Program files\mysql-5.7. One-winx64\bin>mysqld.exe--Initialize A  -D:\Program files\mysql-5.7. One-winx64\bin>mysqld-Install -Service successfully installed.//Service Installation succeeded the  -D:\Program files\mysql-5.7. One-winx64\bin>mysqld.exe-nt--skip-grant-tables

7. Reopen the DOS window and execute mysql-u root

Go to MySQL command line and execute command with MySQL; Update user set Authtication_string=password (' 123456 ') where user= "root"; Set Password=password (' 123456 ');

1Microsoft Windows [version6.3.9600]2(c) -Microsoft Corporation. All rights reserved. 3 4C:\users\administrator>mysqld.exe-nt--skip-grant-Tables5 6C:\users\administrator>mysql-u root7 Welcome to the MySQL Monitor. Commands End With; or \g.8Your MySQL Connection ID is 39Server version:5.7. OneMySQL Community Server (GPL)Ten  OneCopyright (c) -, ., Oracle and/or its affiliates. All rights reserved. A  -Oracle isA registered trademark of Oracle Corporation and/or its - affiliates. Other names trademarks of their respective the owners. -  -Type'Help ;'Or'\h'  forHelp. Type'\c'To clear the current input statement. -  +Mysql>Use MySQL - Database changed +mysql> Update UserSetAuthtication_string=password ('123456')whereUser="Root" A-SetPassword=password ('123456') at-

8. In Task Manager, terminate the MYSQLD process and turn on the MySQL service.

Installation is complete.

Mysql-5.7.11-winx64.zip installation Configuration