My SQL Error 1067: The process terminated unexpectedly!

By | August 8, 2014

My SQL Error 1067If you are trying to install MySQL v5.5 on the Windows machine with Windows 7×64 Enterprise edition and it is installed fine but when you are running the “MySQL Instance Configuration Wizard” it gets paused forever. Then you will come to know that the “MySQL” service hasn’t started, and if I try to restart it, it says you “Windows could not start MySQL Service on Local Computer. Error 1067: The process terminated unexpectedly.”

This error stuck the screen for long time and it does not go until you kill the process.

 If your machine works 100% on every other way and it is 100% good in installing any other compatible databases such as InfiniDB.

Update 2010-12-20

You can try using MySQL v5.1 update but it does not work. The amazing part of this is that if you type “mysqld /?”, or “mysqld -help” then it will not provide you help and if you restart the service manually then it will not display any error message. So it cannot be helpful for you.

Update 2010-12-21

If you install the MySQL 6.0 alpha at this time then it will work.

 Update 2010-12-21

You will find that it deals with the troubleshooting problems with windows. You will even discover that you can generate an error log if this service does not work.

Update 2010-12-21

To see the actual error you need to use this version of MySQL to see this, add “console”.

mysqld –console

downloadnow file buynow learn-more-button-orange

This wil return:

101221 13:57:28 [Note] Plugin ‘FEDERATED’ is disabled.

InnoDB: The InnoDB memory heap is disabled

InnoDB: Mutexes and rw_locks use Windows interlocked functions

InnoDB: Compressed tables use zlib 1.2.3

101221 13:57:28  InnoDB: Initializing buffer pool, size = 203.0M

101221 13:57:28  InnoDB: Completed initialization of buffer pool

InnoDB: Error: log file .\ib_logfile0 is of different size 0 56623104 bytes

InnoDB: than specified in the .cnf file 0 106954752 bytes!

101221 13:57:28 [ERROR] Plugin ‘InnoDB’ init function returned error.

101221 13:57:28 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.

101221 13:57:28 [ERROR] Unknown/unsupported storage engine: INNODB

101221 13:57:28 [ERROR] Aborting

101221 13:57:28 [Note] mysqld: Shutdown complete

Update 2010-12-21

In this version of MySQL you can see the same problem.

To fix all the above problems you need to:

Step 1: As by default it is important to find out the reason why the service fails to start. You need to tell the service to start in the non service mode and will pipe errors to the console.

 mysqld –console

Step 2: in some of the particular cases the deletion of the contents of:

C:\ProgramData\MySQL

Then you need to reinstall the MySQL v5.5 installer and if contains bug then you need to uninstall MySQL v5.5 to fix a problem with a bad installation then it fails to clean up the C:\ProgramData\MySQL which means that it becomes impossible to install the MySQL v5.5  on the machine on that moment without deleting the rogue file.

Hints:

  • You need to ensure that you have killed all the instances of “mysqld” in the process monitor.
  • Then you start to remove the existing services, use “sc and delete MYSQLxx”.

This will fix your MySQL startup problem and your process will kit be terminated. To solve this problem you can even take help of MySQL Repair Tool, which is powerful data recovery software. It will eliminate all the error that your MySQL database encounters. It helps to rectify all the problems that comes with your database even error comes while installation of MySQL. This software is best in recovering all the essential data when it is often in life and death emergency. This software saves retrieved information in Transact-SQL script which is helpful for quick database recreation.

downloadnow file buynow learn-more-button-orange

Steps to fix MySQL Error 1067: The process terminated unexpectedly

Step 1: Download, install and launch the MySQl Database repair tool.
1
Step 2: Click ‘Select’ button to find and add corrupt MySQL database to the application and then select OK. Here you have the option of ‘Repair corrupt database which is stored at default location of MySQL’ and ‘Manual option to selct your database from default location’.
2
Step 3: After the scanning process you can now see the preview of the file in the left panel of the software.
3
Step 4: Now you can start the reairing process, just click on Repair button. A dialoguie box will appear. Click Yes.
4
Step 5: After successful completion of the process, a message box is displayed as ‘repair process finished successfully’. Click ‘OK’ to close the message box.
5