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的配置文件写错了
把这行注视掉