Configuring mysql5.7.16 under Windows

Preparatory work:
Unzip the mysql5.7.16 to the D packing directory,
Then put the My.ini file in the bin directory

Initialize database, configuration related information:
1. Run the Windows command line as an administrator (Special reminder: WIN7 and WIN7 above the system must use the administrator, otherwise the subsequent operation will be wrong)

2. Go to MySQL's Unzip directory D:\mysql-5.7.15-winx64\bin (reminder: The bin directory needs to be entered here or the subsequent operation will be wrong)

3. Register the MySQL service. Run command: mysqld--install MySQL
If it appears: "Service successfully installed." Prompt to prove successful installation of MySQL service

4. Initialize the Data directory
Input command: mysqld--initialize-insecure (Generate password-free root user)
At this point in the MySQL folder will generate a data folder, some folders and files, so that the initialization is successful

5. Start the MySQL service after initialization is complete
Input command: net start MySQL
The MySQL service has started successfully, indicating OK
6. Set the password
mysqladmin-u Root password Password

7. Start using MySQL
Input command: Mysql-u root-p
Then enter the password you just set

Configuring mysql5.7.16 under Windows