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.

Tags: 1067, database, error, linux, mysql, windows, XAMPP