MySQL service cannot be started on Windows (7) (on a local computer) Error 1067: Unexpected Process Termination, mysql1067

MySQL service cannot be started on Windows (7) (on a local computer) Error 1067: Unexpected Process Termination, mysql1067

During this time, many people complained about why their MySQL could not be opened. I have come up with several solutions to the problem that "MySQL service cannot be started on Windows (7) (on a local computer) Error 1067: Unexpected Process Termination:

1. First, check whether the mysql service is enabled in the windows service. If you cannot find the mysql service in the windows service, you need to install the mysql service.

During the installation process, run the following command:> mysqld.exe-install (here, the path of the MySQL Installation File set in path, if you do not specify a path in MySQL in path, you can use cd "MySQL installation path"). After Entering the preceding statement, if the mysql server is not installed on the local computer, the server install successful is displayed, and mysql is existed is displayed when the server is installed!

I will not introduce other installation processes. There are many of them on Baidu!

After the installation is complete, you can see that the windows Service has the mysql service. You can enable the mysql service manually and set it to the automatic mode.

II,

I installed it myself, but the above problem still occurs. This may be because the directory you installed is not the default one or is inconsistent with the one you installed earlier, when the mysql service is started, windows cannot start the mysql service.

Solution: Open the regedit registry and find HEKY_LOCAL_MECHINE-> SYSTEM-> CurrentControlSet-> servers-> MYSQL-> ImagePath to the installation directory: C: \ wamp \ bin \ mysql \ mysql5.6.17 \ bin \ mysqld.exe

In this case, start the MySQL service.

 

3. All the above work has been completed, and it is very likely that MySQL cannot be opened. At this time, most of them are errors in your configuration file, when the thread that calls the configuration file on the mysql server parses the configuration file, the current variable may not exist (it may be because of your writing or version update. The current variable does not exist in this version). At this time, the thread will report an error to the main thread, of course, mysql cannot be enabled.

Solution: in this case, you need to open the windows log file and check that an error occurs in the application mysql (for example, MySQL: unknown variable 'mysql _ sdjfksj = On '), of course, the system may not report an error.

The test method is to comment out the new variables. (Note that, when you comment out these variables, make the same changes to the MySQL configuration file in windows, many failed to take this step .)

After completing the above work, restart the MySQL server.

Note: many times, when you start the mysql service, windows cannot start mysql. This is my in the windows directory. ini and my. if ini is inconsistent, install my. ini overwrites my. INI file, because we have a habit of changing the configuration file in the mysql installation directory, and forget to change the mysql configuration file in windows at the same time.