InnoDB: Error: unable to create temporary file; errno: 13

145 阅读 0 评论 96 点赞

我是靠谱客的博主贤惠冬瓜，这篇文章主要介绍InnoDB: Error: unable to create temporary file; errno: 13，现在分享给大家，希望可以做个参考。

重启mysql

service mysqld start

失败，日志显示如下


181008 16:19:59 InnoDB: Using Linux native AIO
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibIwqDd4' (Errcode: 13)
181008 16:19:59  InnoDB: Error: unable to create temporary file; errno: 13
181008 16:19:59 [ERROR] Plugin 'InnoDB' init function returned error.
181008 16:19:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
181008 16:19:59 [ERROR] Unknown/unsupported storage engine: InnoDB
181008 16:19:59 [ERROR] Aborting

181008 16:19:59 [Note] /usr/sbin/mysqld: Shutdown complete

好像是tmp文件夹权限的问题