WINDOW10 installation Mysql-5.7.20-winx64.zip

WINDOW10 installation mysql-5.7. --Winx64.zip Original https://www.cnblogs.com/ericli-ericli/p/6916285.htmlD:\share\src\window7-mysql\mysql-5.7. --Winx64.zip1. Unzip2. Create My.ini, under the Basedir directory [client]default-character-Set=UTF8 [mysqld] datadir=C:\mysql57\data Basedir=C:\mysql57default-storage-engine=InnoDB #InnoDB character_set_server=UTF8 #skip-grant-Tables #跳过密码验证3. C:\Windows\System32\cmd.exe as Administrator1, enter the program to store the bin directory2, Mysqld--initialize-insecure This command is for the data directory to have a normal MySQL folder and related files3. mysqld Install #结果sucessful才行4. net start MySQL4. Change Password1. Login2. Update Mysql.userSetAuthentication_string=password ('123456')whereUser='Root'; Flush privileges;5. Modify My.ini Comment out skip-grant-tables Restart MySQL after initial login needs to be performed: SET PASSWORD= PASSWORD ('123456'This sentence re-set the password, or nothing can be done! Big uncle's, really laborious ah. This man also encountered the same problem. 

WINDOW10 installation Mysql-5.7.20-winx64.zip