MYSQL不会启动

Question

当我尝试启动MYSQL时，我会看到下面的错误。我删除了./ib_logfile0和./ib_logfile0 1文件，但仍然没有成功。我假设这与无法写入临时文件有关，但我不知道该目录的位置。

140527 15:56:04 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140527 15:56:04 [Note] Plugin 'FEDERATED' is disabled.
140527 15:56:04 InnoDB: The InnoDB memory heap is disabled
140527 15:56:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140527 15:56:04 InnoDB: Compressed tables use zlib 1.2.3.4
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibmZXLyt' (Errcode: 13)
140527 15:56:04  InnoDB: Error: unable to create temporary file; errno: 13
140527 15:56:04 [ERROR] Plugin 'InnoDB' init function returned error.
140527 15:56:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
/usr/sbin/mysqld: File '/var/log/mysql_slow.log' not found (Errcode: 13)
140527 15:56:04 [ERROR] Could not use /var/log/mysql_slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
140527 15:56:04 [ERROR] Unknown/unsupported storage engine: InnoDB
140527 15:56:04 [ERROR] Aborting

Answer 1

Errcode: 13意味着访问被拒绝。假设MySQL试图在/tmp中创建一个文件，这是777，我想这是对selinux或apparmor (在Debian系统上)的不正确配置。

尝试禁用selinux

    echo 0 >/selinux/enforce

如果它没有帮助，停止装置(如果你运行Debian或Ubuntu)

    # /etc/init.d/apparmor stop
    # /etc/init.d/apparmor teardown