MySQL report can ' t create/write to file '/tmp/ib0n3frl ' (Errcode:13-permission denied)

Initializing database error

[Email protected] mysql-5.6.24]#/usr/local/mysql/scripts/mysql_install_db--user=mysql--basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

Installing MySQL system tables ... 2017-04-03 19:52:21 0 [Warning] TIMESTAMP with implicit the DEFAULT value is deprecated. --explicit_defaults_for_timestamp server option (see documentation for more details).

2017-04-03 19:52:21 0 [Note]/usr/local/mysql/bin/mysqld (mysqld 5.6.24) starting as Process 7918 ...

2017-04-03 19:52:21 7918 [Note] innodb:using Atomics to ref count buffer pool pages

2017-04-03 19:52:21 7918 [Note] innodb:the InnoDB memory heap is disabled

2017-04-03 19:52:21 7918 [Note] innodb:mutexes and rw_locks use GCC atomic builtins

2017-04-03 19:52:21 7918 [Note] innodb:memory barrier is not used

2017-04-03 19:52:21 7918 [Note] innodb:compressed tables use zlib 1.2.3

2017-04-03 19:52:21 7918 [Note] innodb:using CPU CRC32 Instructions

/usr/local/mysql/bin/mysqld:can ' t create/write to file '/tmp/ib0n3frl ' (Errcode:13-permission denied)

2017-04-03 19:52:21 7fce976e27e0 InnoDB:Error:unable to create temporary file; Errno:13

2017-04-03 19:52:21 7918 [ERROR] Plugin ' InnoDB ' init function returned ERROR.

2017-04-03 19:52:21 7918 [ERROR] Plugin ' InnoDB ' registration as a STORAGE ENGINE failed.

2017-04-03 19:52:21 7918 [ERROR] unknown/unsupported storage Engine:innodb

2017-04-03 19:52:21 7918 [ERROR] Aborting

2017-04-03 19:52:21 7918 [Note] Binlog End

2017-04-03 19:52:21 7918 [Note]/usr/local/mysql/bin/mysqld:shutdown complete

Report/TMP does not have permission

Workaround:

chmod 777/tmp

Then perform the initial

This article is from "YHT's operations Notes" blog, please make sure to keep this source http://yht1990.blog.51cto.com/9014030/1912718

MySQL report can ' t create/write to file '/tmp/ib0n3frl ' (Errcode:13-permission denied)