Windows installation mysql-5.7.12-winx64 (CommunityServer) Memo

File name Mysql-5.7.12-winx64.msi after download

Think it will be the same as before, the next fool installed and complete the setup, and then start running, but the reality is not, the feeling is a decompression process, and then click the MySQL Command line Shell, can not be used, so refer to some soft-text to solve the problem.

1. Need to initialize MySQL installation directory, generate Data directory

Use the command, generate the Data folder, and write down the string of passwords

2. Start the MySQL service in the console window and prepare to change the root password later

3. Open another console window, execute the following command (mysql-uroot-p), enter the previous password, is logged into the MySQL service

Then use the Set password command to reset the root password

At this point, you can turn off the 2 consoles (dos windows)

Go to the MySQL bin directory, execute the following command, install Mysqld as a service for Windows, and then start

Other steps

1). Append the MySQL bin directory to the system environment variable path

2). Re-copy the original My-default.ini, rename it to My.ini, and then modify the two options, which is similar to the other instructions on the web

Windows installation mysql-5.7.12-winx64 (CommunityServer) Memo