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 try to restart it, it says “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
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.
How To Fix Error 1067: The Process Terminated Unexpectedly MySQL?
Below find out the possible ways to fix MySQL error 1067: the process terminated unexpectedly in a hassle-free manner.
Method 1: Fix The Permissions Problems
The first method that you can try to repair error code 1067 MySQL is to fix a permission issues that are responsible for causing this error. To do so, here are the easy steps:
- First of all, press the Win+ R keys together to open a Run utility
- Then type in there services.msc & hit the Enter.
- Find a service that has an error from services list and click on it
- Select the Propertiesfrom a context menu.
- At this time, if your service is working, then stop it. But, if it’s already stopped, then go to the tab Log On & tap on Browse
- Now, type your account name & Enter the object name to select section
- After this, tap on Check Names and wait for a few minutes.
- Tap on OK button if it’s needed, then input password.
After finishing these steps, you’ll see that your will start working without any issue.
Method 2: Uninstall The SQL Server
Another option you can try to resolve MySQL error 1067 invalid default value error that is uninstall and re-install the server. By following the below steps, you can do so:
Step 1: At first, Back-up a Registry.
Step 2: Next, press the Win + R keys at the same time to launch the Run box. Then, type the regedit & press the Enter.
Step 3: After this, go to the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services & delete all the keys related to the SQL server.
Step 4: Then, reboot your PC after running the clean-up utility and remove all the MySQL server files.
Step 5: Lastly, re-install a server again. This solution may help you to resolve error code 1067 at start service MySQL.
Method 3: Delete Certain Files
If the above two techniques fail to fix MySQL error 1067: the process terminated unexpectedly, then you can erase some log files from install directory. Follow the below steps:
- Just open the Control Panel & let it show all the items via large icons.
- In the second step, you have to tap on Administrative Tools & Services.
- Locate MySQL service, make right-click on it & select Properties.
- Then, click Stop & OK.
- Now, go to a folder where you’ve installed the MySQL. Generally, its C:\Program Files or C:\Program Files (x86).
- Under the folder, click on Data folder, find ib_logfile0 and ib_logfile1, and then delete them.
- Go to the Services window and start the MySQL service again.
Best Way to Error 1067 The Process Terminated Unexpectedly SQL Server
In order to solve MySQL error 1067: the process terminated unexpectedly problem, you can even try the best MySQL Repair Tool. It will eliminate all the error that your MySQL database encounters.
This tool helps to rectify all the problems that comes with your database even error comes while installation of MySQL. And the best part about this software is that – it has ability to save the retrieved information in Transact-SQL script which is helpful for quick database recreation.
With its user friendly interface you can easily use this software because it doesn’t require technical knowledge so non-technical user can also operate it. It has an amazing quality of repairing the corrupted data.
So without any delay download this software and experience its amazing features.
Steps to fix MySQL Error 1067: The Process Terminated Unexpectedly
Time To Conclude
Last but not the least, if you get of this error message then don’t worry, just go through the solutions mentioned in this blog. Simply follow the solutions on how to repair MySQL error 1067: the process terminated unexpectedly.
But if you want the direct solution to fix this issue, then I would like to suggest you to try MySQL Repair Tool. This is the best solution you can try even without any technical help.
That’s all…
Jacob Martin is a technology enthusiast having experience of more than 4 years with great interest in database administration. He is expertise in related subjects like SQL database, Access, Oracle & others. Jacob has Master of Science (M.S) degree from the University of Dallas. He loves to write and provide solutions to people on database repair. Apart from this, he also loves to visit different countries in free time.