160619 17:40:08 [Note] Plugin "FEDERATED" is disabled. 160619 17:40:08 InnoDB: The InnoDB memory heap is disabled 160619 17:40:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions 160619 17:40:08 InnoDB: Compressed tables use zlib 1.2.3 160619 17:40:08 InnoDB: Error: unable to create temporary file; errno: 2 160619 17:40:08 [ERROR] Plugin "InnoDB" init function returned error. 160619 17:40:08 [ERROR] Plugin "InnoDB" registration as a STORAGE ENGINE failed. 160619 17:40:08 [Note] Server hostname (bind-address): "0.0.0.0"; port: 3306 160619 17:40:08 [Note] - "0.0.0.0" resolves to "0.0.0.0"; 160619 17:40:08 [Note] Server socket created on IP: "0.0.0.0". 160619 17:40:08 [ERROR] Can"t start server: Bind on TCP/IP port: No such file or directory 160619 17:40:08 [ERROR] Do you already have another mysqld server running on port: 3306 ? 160619 17:40:08 [ERROR] Aborting 160619 17:40:08 [Note] MySQLa: Shutdown complete
解决方案
40
找错误应该从最先报错的哪里开始，后面提示 能否3306 被占用，那个也只是mysql给出的一个可能的原因，但原因是前面的报错，后面的提示准确与否就打了折扣。
根据出错日志，最先报错的是 InnoDB: Error: unable to create temporary file; errno: 2 ，你看看你的mysql 的 tmpdir 设置的有没有问题，目录能否存在，权限能否对
根据出错日志，最先报错的是 InnoDB: Error: unable to create temporary file; errno: 2 ，你看看你的mysql 的 tmpdir 设置的有没有问题，目录能否存在，权限能否对
CodeBye 版权所有丨如未注明 , 均为原创丨本网站采用BY-NC-SA协议进行授权 , 转载请注明mysql无法启动。偶尔启动成功无法连接，相当于没启动。这是错误代码，请教！