安装MySQL后服务一直无法启动,在services.msc中启动后报错:1037
检查错误日志文件WIN-01408110001.err:
2014-12-28 00:33:54 2c3c InnoDB: Error: unable to create temporary file; errno: 2
2014-12-28 00:33:54 11300 [ERROR] Plugin 'InnoDB' init function returned error.
2014-12-28 00:33:54 11300 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-12-28 00:33:54 11300 [ERROR] Unknown/unsupported storage engine: INNODB
2014-12-28 00:33:54 11300 [ERROR] Aborting
似乎无法创建临时文件夹
检查默认的临时文件夹C:/WINDOWS/TEMP为只读属性,并且无法去除只读属性
只好在配置文件my.ini中增加一句:
tmpdir=e:/temp
修改了临时文件夹的目录,再启动,成功。
转载于:https://blog.51cto.com/executing/1596748