mysql 数据库一次重启报错

2024-03-02 分类：聚合分类

mysqld: Can’t create/write to file ‘/tmp/ibNo70kt’ (Errcode: 13 – Permission denied)
2019-09-12T15:02:00.667642Z 0 [ERROR] InnoDB: Unable to create temporary file; errno: 13
2019-09-12T15:02:00.667646Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-09-12T15:02:00.667650Z 0 [ERROR] Plugin ‘InnoDB’ init function returned error.
2019-09-12T15:02:00.667652Z 0 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2019-09-12T15:02:00.667655Z 0 [ERROR] Failed to initialize builtin plugins.
2019-09-12T15:02:00.667657Z 0 [ERROR] Aborting

2019-09-12T15:02:00.667663Z 0 [Note] Binlog end
2019-09-12T15:02:00.667686Z 0 [Note] Shutting down plugin ‘CSV’
2019-09-12T15:02:00.667690Z 0 [Note] Shutting down plugin ‘MyISAM’
2019-09-12T15:02:00.667902Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

以上是查看MySQL 错误日志：
解决办法，粗暴：chmod 777 /tmp