当我yum update时，只是在CentOS上更新了我的MySQL。 我的网站扔了一些MySQL错误，我发现MySQL没有运行：
# /etc/init.d/mysqld start MySQL Daemon failed to start. Starting MySQL: [FAILED]
我收到这个错误：
2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
该文件不存在，也不在我的/tmp文件夹中。
MySQL升级错误：
# mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck with default connection arguments mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when try ing to connect FATAL ERROR: Upgrade failed
MySQL错误日志：
101107 12:52:28 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 101107 12:52:28 [Note] Plugin 'ndbcluster' is disabled. /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 101107 12:52:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 101107 12:52:28 InnoDB: Started; log sequence number 0 30688749 101107 12:52:28 [ERROR] /usr/libexec/mysqld: unknown option '--skip-bdb' 101107 12:52:28 [ERROR] Aborting 101107 12:52:28 InnoDB: Starting shutdown... 101107 12:52:34 InnoDB: Shutdown completed; log sequence number 0 30688749 101107 12:52:34 [Note] /usr/libexec/mysqld: Shutdown complete 101107 12:52:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
第二次：
101107 12:52:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 101107 13:19:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 101107 13:19:44 [Warning] option 'innodb-additional-mem-pool-size': signed value 204800 adjusted to 524288 101107 13:19:44 [Warning] option 'innodb-log-buffer-size': signed value 204800 adjusted to 262144 101107 13:19:44 [Note] Plugin 'ndbcluster' is disabled. /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 101107 13:19:44 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 101107 13:19:44 InnoDB: Started; log sequence number 0 30688749 101107 13:19:44 [ERROR] /usr/libexec/mysqld: unknown option '--skip-bdb' 101107 13:19:44 [ERROR] Aborting 101107 13:19:44 InnoDB: Starting shutdown... 101107 13:19:49 InnoDB: Shutdown completed; log sequence number 0 30688749 101107 13:19:49 [Note] /usr/libexec/mysqld: Shutdown complete 101107 13:19:49 mysqld_safe mysqld from pid file /var/lib/mysql/dev.system.de.pid ended
这些是我logging的最近的错误。
$ mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck with default connection arguments mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed
首先在你的my.cnf
删除 '–skip-bdb'
尝试再次启动/etc/init.d/mysqld start
它也似乎已升级到更新的版本5.1，所以你将需要运行一次服务器运行mysql_upgrade
在my.cnf（或者/etc/mysql/my.conf或者/etc/my.cnf）中查找log_error指令来找出错误logging的位置。 在Ubuntu上，它默认为/var/log/mysql/error.log，它可能在你的系统上有所不同。 看那里看看什么是MySQL服务器抱怨。