How to fix MySQL Error 1067

When installing MySQL, if you install it in a non-standard directory, then you’ll need to specify where your defaults file’s path is before you can run MySQL or install the MySQL service, otherwise you’ll get Error 1067.

First let’s open up the command prompt.  Navigate to your MySQL install folder and find wherever mysqld.exe is.  Then run this:

mysqld –remove MySql

That will uninstall the MySQL service.
Now reinstall the service with the defaults-file parameter:

mysqld –install <service name> –defaults-file=<full path of “my.ini” file>

For example:

mysqld –install MySql –defaults-file=c:\mysql\my.ini

Enjoy your error-free MySQL install. And don’t forget about the SQL server performance – tune it up!

  • Shane Tolmie
  • Ulliam

    It happends to me too. I could fix it:
    1. stopping the MySQL service in services.msc and starting the MySQL 55 service

  • Dirk

    Nice how all sites show the same solution, but nobody explains how to create a default my.ini file. This is why people hate open source software. You have a nice installer for MySQL, but it NEVER, EVER, installs correctly at once. You first need to create a my.ini file yourself to get rid of the errors, and of course you need to figure out by youself how to do it. God, I hate MySQL. This is the 20+ time I install MySQL on a clean server, and I always try to use a proper directory, but it never ever works.

  • vinodh

    This works . great

  • Sanojoel

    Service successfully installed. but again the same error…

    its not working form me

  • bluelurker

    Yeah it sucks when you don’t find appropriate solutions . :(

  • Pingback: Fix Mysql Server Error 1067 Windows XP, Vista, 7, 8 [Solved]

  • wanderi

    If your mysql was working properly previously, and it has stopped working now; My advice would be: figure out what you have changed in your server previously and change it back to the way it was initially. That error almost killed me. Later I realised that it was caused by enabling AWE memory[innodb_buffer_pool_awe_mem_mb] in mysql 5.0.server . After disabling it everything worked well.