Chinaunix

标题: 数据库出问题了,麻烦哥哥姐姐们帮我看下.小弟感谢不尽.(以解决,谢谢版主) [打印本页]

作者: tchiang    时间: 2007-06-22 12:46
标题: 数据库出问题了,麻烦哥哥姐姐们帮我看下.小弟感谢不尽.(以解决,谢谢版主)
# /usr/local/mysql/bin/mysqld_safe &
[1] 9907
# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/No12webs.pid
070622 12:58:15  mysqld ended

No12webs.err   -------------------------------------------------------
070622 12:58:15  mysqld started
070622 12:58:15  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
070622 12:58:15  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43665.
InnoDB: Doing recovery: scanned up to log sequence number 0 43665
070622 12:58:15  InnoDB: Started; log sequence number 0 43665
070622 12:58:15 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
070622 12:58:15  mysqld ended

[ 本帖最后由 tchiang 于 2007-6-22 14:00 编辑 ]
作者: sakulagi    时间: 2007-06-22 12:58
你执行过mysql_intall_db了么?
作者: olda    时间: 2007-06-22 13:53
执行mysql_intall_db后应该可以解决
作者: tchiang    时间: 2007-06-22 13:57
谢谢版主,重新覆盖安装执行 ./scripts/mysql_install_db  --user=mysql 后正常.
从安装好到现在都很久了,平常没怎么管它.有些都快忘了,以后我会注意到这点.
作者: bjchenxu    时间: 2007-06-27 07:13
一般我都建议rpm方式安装:)




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2