There was a problem when I installed the 5.6 installation method (MySQL free installation download and configuration) before installing 5.7:
The MySQL service failed to start and the service did not report any errors
In fact, in the beginning of this semester to learn MySQL, listen to the teacher classmate said, the problem of login, did not care, but also because the computer has been installed mysql5.6, also did not care about this problem. These two days WIN10 system problem, reinstall the Win7, install 5.7 when the problem arises.
The previous version of the default password is empty, the specific version is not very clear, anyway 5.6 password is empty. 5.7 Security promotion, in the Linux installation 5.7, the installation will generate a random password, stored in the Root/.mysql_secret, if there is no such file, go to the System log to find password, you should be able to find.
But Windows does not know how to solve, but finally found a solution.
Workaround:
From: Windows MYSQL 5.7.9, no boot. Missing data
However, the Data folder is not missing, rename the My-default.ini file to My.ini, move to the bin/directory, execute the command under bin/mysqld--initialize--user=mysql , this command is expected to be an initialized command
Then start the service net start MySQL
Command line display posted on this
Microsoft Windows [version6.1.7601] Copyright (c) theMicrosoft Corporation. All rights reserved. C:\Windows\system32>CD.. C:\Windows>CD.. C +>CD mysql-5.7. --winx64/the boot system could not find the path specified. C +>CD mysql-5.7. --Winx64\binc:\mysql-5.7. --winx64\bin>mysqldInstallService successfully installed. C:\mysql-5.7. --winx64\bin>net start Mysqlmysql service is starting. The MySQL service could not be started. The service did not report any errors. Please type NET helpmsg3534to get more help. C:\mysql-5.7. --winx64\bin>net start Mysqlmysql service is starting. The MySQL service could not be started. The service did not report any errors. Please type NET helpmsg3534to get more help. C:\mysql-5.7. --winx64\bin>mysqld--initialize--user=mysql--Console .- .-21T14: -: -.922112Z0[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. please use--explicit_defaults_for_timestamp server Option (see documentation for Moredetails). .- .-21T14: -: A.669315Z0[Warning] Innodb:new log files created, lsn=45790 .- .-21T14: -: at.106116Z0[Warning] innodb:creating foreign key constraintsystem tables. .- .-21T14: -: at.308916Z0[Warning] No existing UUID have been found, so we assume the TimeThat this server has been started. Generatinga New uuid:79c8386d-37b9-11e6-9709-74867a6179b7. .- .-21T14: -: at.340116Z0[Warning] Gtid table is not a ready-to-be used. Table'mysql.gtid_executed'cannot be opened. .- .-21T14: -: at.355716Z1[Note] A temporary password is generated for[Email Protected]localhost:rr9.8h74twfrc:\mysql-5.7. --winx64\bin>mysql-uroot-prr9.8h74twfrmysql: [Warning] Using a password on the command line interface can be insecure. ERROR2003(HY000): Can't connect to MySQL server on'localhost'(10061)C:\mysql-5.7. --winx64\bin>net start Mysqlmysql service is starting. The MySQL service has started successfully. C:\mysql-5.7. --winx64\bin>mysql-uroot-prr9.8h74twfrmysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL Monitor. Commands End With; or \g.your MySQL connectionIDIs2Server Version:5.7. -Copyright (c) -, ., Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or Itsaffiliates. Other names trademarks of their respectiveowners. Type'Help ;'Or'\h' forHelp. Type'\c'ToClearThe current input statement.mysql> Set Password=password ("'); Query OK,0Rows affected,1Warning (0.00sec) MySQL>Exitbyec:\mysql-5.7. --winx64\bin>mysql-Urootwelcome to the MySQL Monitor. Commands End With; or \g.your MySQL connectionIDIs3Server Version:5.7. -MySQL Community Server (GPL) Copyright (c) -, ., Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or Itsaffiliates. Other names trademarks of their respectiveowners. Type'Help ;'Or'\h' forHelp. Type'\c'ToClearThe current input statement.mysql>Exitbyec:\mysql-5.7. --winx64\bin>
View Code
Mysql5.7.13.zip installation (Windows)