mysql 5.1.50 启动异常

mysql 5.1.50 启动错误
今天下午不知道咋的所有密码都失效，于是重启，发生如下错误：

SQL code

service mysqld restartStarting MySQL......... ERROR! Manager of pid-file quit without updating file.

于是换另外一种方式启动：

SQL code

/usr/local/mysql/bin/mysqld_safe  --user=mysql &120404 20:17:32 mysqld_safe Logging to '/usr/local/mysql/data/localhost.err'.120404 20:17:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data查看log120404 19:34:51 [ERROR] Plugin 'InnoDB' init function returned error.120404 19:34:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.120404 19:34:51 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'innodb_log_arch_dir=/usr/local/mysql/data/'120404 19:34:51 [ERROR] Aborting120404 19:34:51 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete120404 19:34:51 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.pid ended

后来发现 /tmp/mysql.sock没有此文件

请帮忙看看，这是为什么啊。依旧启动不了。


[解决办法]
unknown variable 'innodb_log_arch_dir=/usr/local/mysql/data/'

你my.cnf的配置文件写错了 

把这行注视掉

查看更多 下一篇