MySQL does not start: Error: unable to create temporary file

Created:

2016-11-16 12:57:37 UTC

Modified:

2017-08-08 13:08:19 UTC

0

Was this article helpful?


Have more questions?

Submit a request

MySQL does not start: Error: unable to create temporary file

Applicable to:

  • Plesk for Linux

Symptoms

  • Service mysqld does not start. Plesk returns 500 Error on Login screen. The following error in the ' /var/log/mysqld.log ':

    141001  0:36:31 InnoDB: Using Linux native AIO
    ^G/usr/libexec/mysqld: Can't create/write to file '/tmp/ibVc44NP' (Errcode: 13)
    141001 0:36:31 InnoDB: Error: unable to create temporary file; errno: 13
    141001 0:36:31 [ERROR] Plugin 'InnoDB' init function returned error.
    141001 0:36:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed
    141001 0:36:31 [ERROR] Unknown/unsupported storage engine: InnoDB
    141001 0:36:31 [ERROR] Aborting
    141001 0:36:31 [Note] /usr/libexec/mysqld: Shutdown complete
    141001 00:36:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  • psa service restart returns the following error:

    # /etc/init.d/psa restart
    Stopping sw-engine-fpm: [ OK ]
    Starting sw-engine-fpm: [ OK ]
    ERROR 1286 (42000) at line 1: Unknown table engine 'InnoDB'

Cause

No permission to create a file in /tmp directory.

Resolution

Grant the necessary permissions:

#chmod 1777 /tmp
#chmod 0555 /
Have more questions? Submit a request
Please sign in to leave a comment.