MySQL 5.5启动失败Fedora 16

Question

我从repos安装了mysql和MySQL服务器(MySQL版本5.5)。然后试图启动它，但得到了一个错误。

[root@server]# service mysqld start
Redirecting to /bin/systemctl start  mysqld.service
Job failed. See system logs and 'systemctl status' for details.

这是日志：

121118  2:41:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121118  2:41:38 [Note] Plugin 'FEDERATED' is disabled.
121118  2:41:38 InnoDB: The InnoDB memory heap is disabled
121118  2:41:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121118  2:41:38 InnoDB: Compressed tables use zlib 1.2.5
121118  2:41:38 InnoDB: Using Linux native AIO /usr/libexec/mysqld: Can't create/write to file '/tmp/ibhsfQfU' (Errcode: 13)
121118  2:41:38  InnoDB: Error: unable to create temporary file; errno: 13
121118  2:41:38 [ERROR] Plugin 'InnoDB' init function returned error.
121118  2:41:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121118  2:41:38 [ERROR] Unknown/unsupported storage engine: InnoDB
121118  2:41:38 [ERROR] Aborting

121118  2:41:38 [Note] /usr/libexec/mysqld: Shutdown complete

121118 02:41:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

新的安装，没有改变之前，只是运行yum更新。

以下是systemctl状态跟踪

[root@linyansho /]# systemctl status mysqld.service
mysqld.service - MySQL database server
  Loaded: loaded (/lib/systemd/system/mysqld.service; disabled)
  Active: failed since Sun, 18 Nov 2012 02:45:19 +0300; 5min ago
  Process: 864 ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID (code=exited, status=1/FAILURE)
  Process: 863 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
  Process: 842 ExecStartPre=/usr/libexec/mysqld-prepare-db-dir %n (code=exited, status=0/SUCCESS)
  CGroup: name=systemd:/system/mysqld.service

Answer 1

确保您在/和数据dir中有足够的空间。

1. 在ps -ef \ grep -i mysql中杀死mysql的所有进程
2. 如果您看到在默认数据目录下生成的任何ibdata文件，也可以删除iblogfile1,2 1，2，因为它是一个新的安装，不需要安全地备份它们。
3. chown -R mysql:root /var/lib/mysql
4. chmod -R 775 /var/lib/mysql也具有/etc/my.cnf的相同权限。
5. 现在尝试通过发出/etc/init.d/mysql启动和尾部-f /var/log/mysqld.log启动实例。如果您收到任何错误消息，它应该开始时没有任何问题。

Answer 2

检查临时文件权限。

步骤：

1. 转到您的my.cnf文件并找到tmpdir变量。它将类似于tmpdir=/var/untd/tmp。
2. 更改文件权限，如下所示。chown mysql:mysql /var/untd/tmp
3. 现在您可以使用MySQL mysqld_safe mysqld_safe -user=root&