MySql error 1067

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.