日期:2014-05-16  浏览次数:20666 次

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

service mysqld restart
Starting 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
查看log
120404 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] Aborting

120404 19:34:51 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

120404 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的配置文件写错了 

把这行注视掉