Mysql error

Hello,

I am trying to start mysql but I am getting the following error

*********
MySQL manager or server PID file could not be found! [FAILED]

Starting MySQL................................... [FAILED]
*********

I checked my hostname.err file in /var/lib/mysql and this is the error message it shows. 070130

17:59:41 mysqld started 070130 17:59:42 [ERROR]

/usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130

17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130

17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 mysqld ended

Ans:

I found a solution to anyone else who may be having this problem. First start mysql using skip grant tables

root@ns1 [/var/lib/mysql/mysql]# service mysql start --skip-grant-tables

Starting MySQL [ OK ]

now with mysql started, you can repair the mysql/user table

root@ns1 [/var/lib/mysql/mysql]# mysqlcheck -r mysql user mysql.user

warning : Number of rows changed from 1558 to 1556 status : OK

now that its repaired, restart mysql

root@ns1 [/var/lib/mysql/mysql]# service mysql stop

Shutting down MySQLs [ OK ]

root@ns1 [/var/lib/mysql/mysql]# service mysql start

Starting MySQL [ OK ]

--------------------------------------------