1067 Error startup error and "service MySQL unexpected Stop" workaround

MySQL Startup report 1067 error, the system log is "service MySQL unexpected Stop" in the MySQL log is: "Plugin ' federated ' is disabled"

I find solutions on the Internet:

1, in the My.ini file in [mysqld] add a row tmpdir= "d:/mysql/data/" modified, or can not start or could start but shutdown after the same problem, and then I did a second step, restart normal.

2, delete the data directory in addition to the database folder other files, restart MySQL, problem solving.

If the above method does not first use the following solution

The solution on my machine is:

Modify%windir%my.ini, increase
[Mysqld]
#设置basedir指向mysql的安装路径
Basedir=d:programtoolsmysql
Datadir=d:programtoolsmysqldata

Workaround three

1. Check your MySQL directory for system user privileges.
2. Delete your%windows%/my.ini file.
3. Check that your C:/MY.CNF file is configured correctly.