MySQL boot 1067 error, the system log is "service MySQL stopped unexpectedly" in the MySQL log is: "Plugin \ ' federated\ ' is disabled"

MySQL boot 1067 error, the system log is "service MySQL stopped unexpectedly" in the MySQL log is: "Plugin \ ' federated\ ' is disabled"

The specific contents of the error are:

121012 11:35:03 [Note] Plugin ' federated ' is disabled.
121012 11:35:03 InnoDB:Error:unable to create temporary file; Errno:2
121012 11:35:03 [ERROR] Plugin ' InnoDB ' init function returned ERROR.
121012 11:35:03 [ERROR] Plugin ' InnoDB ' registration as a STORAGE ENGINE failed.
121012 11:35:03 [ERROR] unknown/unsupported table Type:innodb
121012 11:35:03 [ERROR] Aborting

I found a solution on the Internet:

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

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

The way I did it, but no, I figured out a way to do it.

The first step:

Just delete the Ib_logfile0 and ib_logfile1 two files in the MySQL directory
Step Two:

Find out why you can't start: MySQL does not automatically initialize the Tmpdir (temporary file directory) when it is installed, so add the Tmpdir path to the configuration file My.ini.

Finally, add the following in My.ini:

[Mysqld]
#自己指定的临时文件目录
Tmpdir= "E:/program files/mysql/mysql Server 5.1/temp/"

MySQL boot 1067 error, the system log is "service MySQL stopped unexpectedly" in the MySQL log is: "Plugin \ ' federated\ ' is disabled"