MYSQL : /usr/libexec/mysqld: Can’t create/write to file ‘/tmp/’ (Errcode: 13)

Problems :

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

121129 10:15:13 [Note] /usr/libexec/mysqld: Shutdown complete

 

/etc/init.d/mysql start command returned following output:

[root@nms-sa ~]# /etc/init.d/mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

 

Solutions :

# chown root:root /tmp
# chmod 1777 /tmp
# /etc/init.d/mysqld start

 

Source : http://www.cyberciti.biz/faq/mysqld-innodb-error-unable-to-create-temporary-file/