What should I do if mysql crashes after installing it?

The solution to the problem of crash when installing mysql: First stop the Mysql service and uninstall MySQL; then delete the installation directory and data storage directory; then query MySQL on the c drive; and finally reinstall MySQL.

Recommended: "mysql video tutorial"

## Heavy When installing mysql, it is always the last step after submitting the configuration. The installation fails, the process manager shows that the program is unresponsive, and a 1067 error is reported when the mysql service starts.It took several days. God, I tried several methods on the Internet but failed. Finally, I tried the following steps with the attitude of giving it a try and finally succeeded:

1. Stop the Mysql service and uninstall MySQL.

2, delete the installation directory and data storage directory (delete cleanly, pay attention to hidden folders)

C:\ProgramData\MySQL;

C:\Program Files (x86)\MySQL;

3. Query mysql in the registry and delete them all (this step is very critical. The main reason for installation failure is that the registry is not deleted cleanly)

The following is a method to completely delete the registry:

(1) Enter the registry: Run >>regedit to the following interface (press Delete as shown below):

## (2) Clean up the following three directories:

a.HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL

b.HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services \Eventlog\Application\MySQL

c.HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL

MySQL registry ControlSet001, ControlSet002, are not necessarily 001 and 002, they may be ControlSet005, 006, etc. When deleting, just delete them;

Check if there is a my.ini file in the C:\WINDOWS directory and delete it

4, query MySQL on the c drive (it may be hidden, just show the hidden files), delete all

5, reinstall MySQL, select a name that has not been used before during the configuration process (MySql4, if you still use the original MySql, cannot start the service)

The above is the detailed content of What should I do if mysql crashes after installing it?. For more information, please follow other related articles on the PHP Chinese website!