Unable to start MYSQL service "1067 unexpected process termination" solution summary and ultimate method _ MySQL

At the beginning, I installed and configured MySQL download, installation, configuration, and use (win7x64) according to the method in Baidu's experience. However, the error code 1067 is always displayed in the subsequent steps. Solve the problem slowly. Here we will summarize various methods that cause mysql to prompt that MYSQL server cannot be started. at the beginning, we will install and configure MySQL download, installation, configuration, and use (win7x64) according to Baidu's experience, however, the error code 1067 is always displayed in the subsequent steps. Solve the problem slowly.
Here we will summarize some solutions that cause mysql to prompt that the MYSQL service "1067 process unexpectedly terminated" cannot be started. I encountered this problem because I checked a lot of methods. I finally saw a forum discussion and tried it. Here are some methods on the internet. the last method I can use is put at the end:
When the MySql service is enabled, "windows cannot start mysql service (on a local computer. Error 1067: unexpected termination of the process) ", check that the mysql service does not depend on the security system, so I suddenly thought of viewing the system log and found many MySql errors, finally, find the problem.

When the MySql service is enabled on the win7 server, the following message is displayed: "The mysql service cannot be started on windows (on a local computer. Error 1067: Unexpected process termination )" Solution 1Log on to the "Event Viewer" and "application" and find many MySql errors. the Default storage engine (InnoDB) is not available. therefore, go to the MySql installation directory and find my. in ini, change default-storage-engine = INNODB to MYISAM. Start the MySql service immediately.

Solution 2

When you reinstall mysql, the system always prompts "the MYSQL service cannot be started, error 1067 process unexpectedly terminated
It is useless to restart and fix the registry,
I checked it online. it's useless to modify basedir.
I use mysql5.8,
Find it and remember that the integrated environments such as wampserver and pc_webserver were installed,
These software will write my. ini, php. ini to the C: WINDOWS directory and set it to read-only

Solution:

Delete the my. ini file in the windows directory,

Reinstall mysql. The service is started successfully...

Solution 3

1. run winmysqladmin to generate the my. ini file.
2. start mysql service with mysqld-install
3. net start mysql startup mysql service display normal
When the mysql-u root-p connection is used, an error indicating that the server has not been started is reported. check the server service. it is true that the mysql service has not been started. if the mysql service is manually started, a 1067 error is generated and the mysql service has been re-installed several times, the error persists. Check that all configurations are correct.

My system environment is win2003 mysql 4.0.12.
Solution: copy my. ini generated by winmysqladmin to c: windows and start mysql.
This has not been tried: in fact, you do not need to reconfigure as long as you click mysql.exe in the/bin directory in turn

Mysqld.exe

Mysqld-nt.exe

Winmysqladmin.exe

The prompt box appears, and then the cancle is dropped.

Then click winmysqladmin.exe and select start service on the small icon in the lower right corner.

Solution 4

In fact, some of the above are not successful after the trial, and finally I saw a post in a forum-"mysql 5.6 Greening caused me to crash. System error 1067. The method of the 7th floor is not to add my. ini file, but in the original my-default.ini to modify, the original reply is as follows:

"My mysql version is 5.6.12. after decompression, create the my. ini file as you said on the Internet. If you encounter problems and cannot find the answer, it's crazy.
Later think about, why don't bring their own my-default.ini. So remove the # annotation configuration in the my-default.ini.
Run the following command in cmd:
Mysqld.exe -- install
Net start mysql
Successful !!

"

I think about it. I noticed that "Step 3: configure the default file" in Baidu's experience at the beginning of this article said: "In theory, we can directly install the service now, but because it is a default configuration, we may encounter many problems when using it. For example, the Chinese characters in it are all garbled characters, so we recommend that you configure the default file first. In the mysql-x.x.xx-winx64 (small make up is 5.6.17 according to their own version) directory, create a new my. ini. Copy the following code and save it. My. ini replaces the drop-down my-default.ini file ." Although solution 4 has been solved for the time being, there will be many problems later. Let's take a look at it first. then, we can't follow the above method and try again. The perfectionist does have to spend a lot of time. Simple use should not be too difficult!