fixed SQL Plugin FEDERATED is disabled

WampServer , MySQL 5.5.8

电脑意外关机后，服务启动失败，自动关闭
查看了mysql.log 错误日志

201211  0:52:24 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
201211  0:52:24  InnoDB: Error: unable to create temporary file; errno: 2
201211  0:52:24 [ERROR] Plugin 'InnoDB' init function returned error.
201211  0:52:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
201211  0:52:24 [ERROR] Unknown/unsupported storage engine: InnoDB
201211  0:52:24 [ERROR] Aborting

201211  0:52:24 [Note] wampmysqld: Shutdown complete

以上

网上找到方法,在My.ini文件中的[mysqld]中增加一行

我的是[wampmysqld]

tmpdir=d:/wamp/tmp

[mysqld] 增加一行，注意是 mysqld

federated

重启服务成功

201214  8:36:43  InnoDB: Initializing buffer pool, size = 128.0M
201214  8:36:43  InnoDB: Completed initialization of buffer pool
201214  8:36:43  InnoDB: highest supported file format is Barracuda.
201214  8:36:48  InnoDB: 1.1.4 started; log sequence number 1785000
201214  8:36:51 [Note] Event Scheduler: Loaded 0 events
201214  8:36:51 [Note] wampmysqld: ready for connections.
Version: '5.5.8-log'  socket: ''  port: 3306  MySQL Community Server (GPL)

顺便记下

skip-external-locking

skip-name-resolve