The MySQL service (located on the local computer) cannot be started on Windows (7) Error 1067: The process terminated unexpectedly

During this time, many people are complaining about why their MySQL is not open. On "Windows (7) cannot start the MySQL service (located on the local computer) error 1067: The process terminated unexpectedly" This problem, I think of several solutions:

First, in the Windows service to determine whether the MySQL service is turned on, if you do not find the services of MySQL in Windows services, then you need to install the MySQL service.

The installation process can be used in the form of a command line, enter the following command, 5.1 after the version of the command:>> Mysqld.exe-install (here I set the path of the MySQL installation file in path, does not specify the path in the path of MySQL classmate, You can use the CD "MySQL Installation path"), after entering the above statement, if there is no MySQL server installed on the local computer, you can see that the server install successful is displayed, the installed will show MySQL is existed!

Other installation process I will not introduce, Baidu above a lot!

After installation, this time you can see that the Windows service has a MySQL service, you can manually turn on the MySQL service, you can manually set to Automatic mode.

Two

Installed yourself, but there is still the above situation, this may be because you install the directory is not the default or your previous installation of inconsistencies, when the start of the Windows will not start the MySQL service.

Solution: Open the Regedit registry and locate Heky_local_mechine->system->currentcontrolset->servers->mysql->imagepath Modify to install directory: C:\wamp\bin\mysql\mysql5.6.17\bin\mysqld.exe

At this time to start the MySQL service, there is no problem.

Third, when the above work has been completed, or very likely in the case of MySQL can not open the situation, this is mostly the error in your configuration file, the MySQL server calls the configuration file thread when parsing the configuration file, it is possible that the current variable does not exist ( It may be that you write or it is a version update because the current variable does not exist in this version, and so on, the thread will report the error to the main thread, of course, there will be a state of MySQL can not be opened.

Solution: This is the time to open the Windows log file, see the application MySQL under the error (such as: Mysql:unknown variable ' mysql_sdjfksj=on '), of course, the system may not report errors.

The method of testing is to comment out their new variables, (note that while commenting out these variables, the MySQL configuration file under Windows also makes the same changes, many students forget this step, repeated, are unsuccessful.) )

Once you have done the above work, restart the MySQL server, and that's it.

Note: many times, When you start the MySQL service, Windows cannot start MySQL, which is caused by My.ini inconsistencies in the Windows directory under My.ini and the installation directory, overwriting the My.ini under the Windows directory with the My.ini file under the installation directory because we have a habit of changing my SQL installation directory under the configuration file, forget to change the MySQL configuration file under Windows at the same time.

The MySQL service (located on the local computer) cannot start on Windows (7) Error 1067: The process terminated unexpectedly