MySQL error 1067 on Windows 8 (error 87)

I installed MySQL 5.0 on a Windows 8 machine, everything worked out just fine, but the next day, after a reboot, the MySQL service would not start. The error message was

Could not start the MySQL service on Local Computer.
Error 1067: The process terminated unexpectedly.

I tried a bunch of things, even reinstalling MySQL, but it wouldn’t start anymore.

Looking at the error logs (in the data directory, in my case in C:\Program Files\MySQL\MySQL Server 5.0\data, the file is called server.err), I read

InnoDB: Operating system error number 87 in a file operation.

Thanks to a blog post on, I finally managed to get the thing up and running again by adding


to my my.ini. This finally solved it. Thanks Alex!

Check the blog post as it contains some other very useful learnings when dealing with MySQL on Windows.



Leave a Reply

Your email address will not be published. Required fields are marked *

Spam Protection by WP-SpamFree