MYSQL startup reports a 1067 error. In the system log "service mysql unexpectedly stopped", the Mysql Log is: "Plugin \ 'federated \ 'is disabled"
The error details are as follows:
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' registry 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 MY. after the [mysqld] In the INI file adds a line tmpdir = "D:/MySQL/data/", it still cannot be started or can be started, but the same problem occurs again after shutdown, then I made the second step and restarted normally.
2. Delete all files in the DATA directory except the database folder, restart mysql, and solve the problem.
I tried the above method but I couldn't. I found a solution similar to the above.
Step 1:
You only need to delete the ib_logfile0 and ib_logfile1 files under the MySQL directory.
Step 2:
Find out the cause of failure: MySQL does not automatically initialize tmpdir (temporary file directory) during installation, so you need to add the tmpdir path to the configuration file my. ini.
Add the following in my. ini:
[Mysqld]
# Self-specified temporary file directory
Tmpdir = "E:/Program Files/MySQL Server 5.1/Temp /"