Solve win7 system MySQL service can not start error 1067 four methods

Some win7 system users when landing mysql or reinstall mysql appears "can not start MYSQL service, error 1067", and restart, repair the registry can not Solve the problem. So how can I solve the problem that the MySQL service cannot be started? In response to this problem, the following small series of research to sort out four solutions, together to see how to solve the Win7 system MySQL service can not start the error 1067.

Workaround 1:

1, open the my.ini file, find the default-storage-engine=InnoDB line, and change it to default-storage-engine=MyISAM;

2, delete ib_logfile0 and ib_logfile1 in the Data directory under the MySQL installation directory;

3, find the InfoDB directory specified when configuring the MySQL server, delete ibdata1

According to the my.ini file: #*** INNODB Specific options *** innodb_data_home_dir="D:/";

4, restart the MySQL Service.

Solution 2:

Delete the my.ini file in the windows directory, reinstall mysql, the service starts successfully.

Workaround 3:

1, execute winmysqladmin, generate my.ini file;

2, mysqld -install Start mysql service;

3, Net start mysql start mysql service shows normal when the mysql -u root -p connection when the server does not start the error, check the server service, indeed mysql service is not started, manual start to generate 1067 error, re-installed several times mysql, the error remains . Look at each configuration without errors. Copy my.ini generated by winmysqladmin to c:windows and then start mysql all OK!

This has not been tried: in fact, you do not need to reconfigure you just click mysql.exemysqld in the /bin directory. After the exemysqld-nt.exewinmysqladmin.exe prompt box appears, you can directly cancel, and then click winmysqladmin.exe to select the startup service on the small icon on the lower right foot.

Solution 4:

1, turn off wamp, then open the downloaded wampserver installation package, install it, directly overwrite the previous installation file, so the mysql configuration problem is directly automatic Repaired,

2, start MySQL, it should be fine.

win7 system MySQL service can not start the four solutions of error 1067, users can take any method to solve, simple and practical tips, I hope everyone can master.