Local failed to start MySQL service, reported error: 1067, process terminated unexpectedly

The local computer fails to start the MySQL service error 1067 process terminated unexpectedly this situation is generally a My.ini file configuration error

First find this file: Default installation path

C:/Program Files/mysql/mysql Server 5.1/my.ini

Open this file found: Default-storage-engine=innodb is probably in line 84.

Change the value of Default-storage-engine to: MYISAM, this time, the MySQL service can be started.

But there's still a problem: because the databases you created before are still there (if not deleted),

Default path:

C:/Documents and Settings/all users/application data/mysql/mysql Server 5.1/data

This problem may come up at this point:

The Efault-storage-engine set for the first time is not the same as the value of the second setting, which may cause

1: Found Unable to select Add transaction support Data Engine InnoDB

2: May say does not support InnoDB etc.

Workaround:

Delete: Ib_logfile0

Ib_logfile1

Ibdata1

Restart the service and make the achievement OK again

Local failed to start MySQL service, reported error: 1067, process terminated unexpectedly