When installing MySQL56, stop at the start service step

Problem:

When installing MySQL56, the Setup program does not complete the step to start service, and the system always prompts "the installation time is longer than expected, whether to stop the installation step (configuration of MySQL sever 5.6.21 is taking Longer than expected. Want to Continu waiting ... ), uninstall the repro installation or you are experiencing this problem.

After the execution I tried to manually start the MySQL service and the service failed to start. Then C:\Program files\mysql\mysql Server 5.6 Folder My-default.ini The content of the price is basically empty (like the installation directory, the user name password is all empty), so it must be the installation failed.

Solution:

There are two problem solutions on the Web (try it out, but the first one doesn't solve my problem, and the backup solution solves my problem)

The first is the failure of the start service is to uninstall MySQL, and delete the information in the registry, all the MySQL-related folders (including hidden folders) are all deleted, and then re-install.

The second is to start the MySQL service failure method, the reason is that the user is My-default.ini file information error, the contents of this file correction can be started correctly.

I think I may be MySQL Kemben is not installed successfully, so simple to improve the content of My-default.ini file should not function, I choose the first method here to experiment.

1. Run the MySQL Setup program, select Remove, and uninstall all of the
2. Delete MySQL directly under the installation directory (my C:\Program files\)
3. Delete all the MySQL-related things in the registry, click "regedit", "Run the program," Open the registry and remove everything from the following locations

Hkey_local_machine/system/controlset001/services/eventlog/applications/mysql

Hkey_local_machine/system/controlset002/services/eventlog/applications/mysql

Hkey_local_machine/system/currentcontrolset/services/eventlog/applications/mysql

1. In fact, this time is not completely deleted, MySQL also has some data files in the installation directory in the other folder inside, there is a folder "program Data" There is MySQL, delete, in fact, the most convenient solution is the C drive and the installation path of the disk directly search "MySQL", Delete that information one by one.
2. Reinstallation still has this problem

Alternate scenario: Download additional MySQL installation packages

1. Download the MySQL archive from the Internet (http://blog.csdn.net/heizistudio/article/details/9916093), unzip it under the D:/mysql folder
2. According to the method provided in the previous URL to modify the contents of the My-default.ini file, mainly to set the port number of the database, MySQL basic address, data address, server startup program location and so on!
3. Create a new system variable in the Windows environment variable Mysql_home variable value is D:\MySQL,
4. Add%mysql_home%bin to Path
5. The Command window is located under the D:\MySQL\bin folder, and MySQL is registered as a Windows system service:

Mysqld install mysql–defaults-file= "D:\MySQL\my-default.ini" (Uninstall service for

Mysqld Remove)

1. Turn on mysql:net start MySQL (shutdown: net stop MySQL)
2. Change the root password to 123456

1) Navigate to the Bin folder under the installation directory (my is D:\mysql\bin)

2) Mysql–uroot

3) UPDATE user SET Password=password ("12456") WHERE user= ' root '; (The semicolon here must be added)

4) Complete!!!

Now think of the two solutions above, perhaps the second is also possible. is to modify My-default.ini directly.

When installing MySQL56, stop at the start service step