数据库出问题了,麻烦哥哥姐姐们帮我看下.小弟感谢不尽.(以解决,谢谢版主)

tchiang

# /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

你执行过mysql_intall_db了么？

olda

执行mysql_intall_db后应该可以解决

tchiang

谢谢版主，重新覆盖安装执行 ./scripts/mysql_install_db  --user=mysql 后正常．
从安装好到现在都很久了，平常没怎么管它．有些都快忘了，以后我会注意到这点．

bjchenxu

一般我都建议rpm方式安装：）