If 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.
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.
If you install the MySQL 6.0 alpha at this time then it will work.
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.
To see the actual error you need to use this version of MySQL to see this, add “console”.
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
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.
Step 2: in some of the particular cases the deletion of the contents of:
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.
- 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.