List:General Discussion« Previous MessageNext Message »
From:Haider Raza Date:January 2 2007 4:26pm
Subject:mysqld_safe: STOPPING server from pid file astguiclient.pid
View as plain text  
Hi,

    Can someone please tell me what is going on? I keep getting this error
everytime I try to start the mysql server and there is no information about
this pid file error anywhere. Any help offered will be greatly appreciated.

root@astguiclient:/var/lib/mysql# mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/astguiclient.pid
061226 20:41:25 mysqld ended

and in the /var/lib/mysql/astguiclient.err file I see the following
information:

061226 20:41:23  mysqld started
061226 20:41:24  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...
061226 20:41:25  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43724.
InnoDB: Doing recovery: scanned up to log sequence number 0 43764
InnoDB: Last MySQL binlog file position 0 79, file name ./astguiclient-
bin.000003
061226 20:41:25  InnoDB: Flushing modified pages from the buffer pool...
061226 20:41:25  InnoDB: Started; log sequence number 0 43764
061226 20:41:25  [ERROR] Fatal error: Can't open privilege tables: Table '
mysql.host'    (NO IDEA WHAT THIS MEANS!!!!)
061226 20:41:25  mysqld ended

Thanks.

Thread
mysqld_safe: STOPPING server from pid file astguiclient.pidHaider Raza2 Jan