MySQL守护进程启动失败

Question

当我运行yum更新时没有更新。我试图安装php-soap (这是失败的)，在网上我发现我应该运行这个：

wget -q -O - http://www.atomicorp.com/installers/atomic.sh |sh

运行之后，"yum“成功运行。然后，我运行yum更新，只是为了检查更新，并说是的一些软件包。我注意到有一些mysql之类的。现在mysql不再运行了，它也不允许我启动它(我得到了"MySQL守护进程启动失败“)

想法？

下面是我的mysql.log的一部分：

100616 16:37:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] option 'innodb-additional-mem-pool-size': signed value 512000 adjusted to 524288
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100616 16:37:53 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
100616 16:37:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100616 16:37:53  InnoDB: Started; log sequence number 0 1650102
100616 16:37:53 [ERROR] /usr/libexec/mysqld: unknown option '--skip-bdb'
100616 16:37:53 [ERROR] Aborting

100616 16:37:53  InnoDB: Starting shutdown...
100616 16:37:58  InnoDB: Shutdown completed; log sequence number 0 1650102
100616 16:37:58 [Note] /usr/libexec/mysqld: Shutdown complete

Answer 1

这些可能是显而易见的建议，但您的my.cnf文件是否包含"set-variable"？

你试过运行mysql_upgrade吗？

正如我以前多次学习过的那样--无论是MySQL还是应用程序/框架升级，总是在任何类型的升级之前备份数据库。执行SQL转储只需一两分钟，可以节省您几个小时甚至几天的头痛时间。

Answer 2

mysql错误日志显示了什么？

如果什么都没有出现，请尝试暂停启动脚本：

strace -f -o strace.output /etc/init.d/mysql.server start

这将写入文件strace.output启动MySQL守护进程时进行的所有系统调用。当调试这类问题时，strace通常很有用。最后几行可能有用。

希望这能有所帮助。