MySQL Environment construction (and Chinese garbled solution)

The computer has MySQL method installed on the uninstall computer of MySQL:
My Computer--"right"--"Properties--" Advanced system settings--"Environment variables--" system variables inside--"to find the environment variable path
Example: C:\WorkSofe\Java\jdk1.7.0_55\bin; C:\WorkSofe\Java\jre7\bin; E:\mysql;
Delete the original MySQL path (the above example is to remove the E:\mysql)
Delete the original MySQL file (you must first turn off MySQL service: net stop MySQL)
Open the DOS command line. Input command sc delete mysql (delete mysql service)
Since 5.7 is free from installation, the downloaded packages are free of installation and must be set to use.

Configuration steps

1. Installation steps: The first step to find the MySQL compression package (32-bit and 64-bit steps, the name is not the same, here I use 64 bit to demonstrate), and to extract, extract to (D-plate E-disk F, whatever you unzip to which disk)

2. If I unzip to the root of the F drive. The root directory of the F-disk,

3. Open mysql-5.7.17-winx64 This folder, after opening

4. Copy the path, then find a My-default.ini and rename the file to My.ini file,

5. Then open the My.ini file, open it, find the code in the Red box,

6.basedir = Just let you copy the path, DataDir = just let you copy the path after adding a \data, port = 3306, to save, after the last change,

7. Create a Data folder in the current directory of the My.ini file.

8. Start, search cmd, right click cmd to run as Administrator,

9. Then enter pushd F:\mysql-5.7.17-winx64\bin,--------------------F:\mysql-5.7.17-winx64\bin The origin of this path

10. Then enter Mysqld-install, and the Service successfully will be displayed after success installed
11. Then enter Mysqld--initialize-insecure--user=mysql, waiting for a period of time after the MySQL user name is initialized to the root password is empty.
12. Then enter the net start MySQL startup service. Show Service started successfully
13. Then enter Mysql-u root-p return to let you enter the password (password blank), continue to enter, enter after MySQL

14. Then enter set password = password ("root"), reset the password to root, display Quikey OK successfully. Then enter quit to quit database shutdown cmd
15. "My Computer--" Properties-"advanced system settings--" Environment variables--"System settings found path. Then the edit cursor moves to the end, if at the end he does not have a semicolon. Then you add an English semicolon yourself, then copy and paste the 9th step bin path to the back F:\mysql-5.7.17-winx64\bin and then determine OK to open the cmd input mysql-u root-p Enter the password to login successfully. End of tutorial

Register good MySQL after modifying My.ini
Database appears??? In the My.ini file [mysqld] before adding the following content

[client]default-character-set=utf8[mysqld]default-storage-engine=INNODBcharacter-set-server=utf8collation-server=utf8_general_ci[mysql]default-character-set=utf8

MySQL Environment construction (and Chinese garbled solution)