Install mysql5.7 in zip mode today in WINDOWS10 64-bit environment, to the last step, the MySQL service cannot start.
The installation steps are as follows:
1. Configure Environment variables
My Computer, properties, advanced environment variable->path
Example: C:\Program files\mysql\mysql Server 5.6\bin
Note is appended, do not overwrite
2. Modify My-default.ini
In which the configuration is modified or added:
[Mysqld]
Basedir=c:\program files\mysql\mysql Server 5.6 (MySQL directory)
Datadir=c:\program files\mysql\mysql Server 5.6\data (the directory where MySQL resides \data)
3. Run cmd as administrator (win10 right-left corner Start button Select Run cmd as Administrator )
Run cmd as administrator (be sure to run as administrator, or not have enough permissions),
Input: cd C:\Program files\mysql\mysql Server 5.6\bin into the bin folder of MySQL (regardless of whether the environment variable has been configured, but also to enter the Bin folder, or after the start of the service will still report error 2)
Enter Mysqld-install (if run without administrator, there will be an error due to insufficient permissions: Install/remove of the Service denied!)
Installation Successful
4. Run mysqld--initialize(title problem, if no init does not exist data directory, natural cannot start successfully)
5. After the installation is successful, start the service, continue to enter in cmd: net start MySQL, the service started successfully!
After the service started successfully, you can log in, enter Mysql-u root-p (no password for the first login, press ENTER directly), Login success!
Mysql Service failed to start service did not report any errors