Re: Fixing corrupt mysql table

["Robert S" <robert.spam.me.senseless@gmail.com>]

> As Bob mentioned, this is most likely because you deleted the
> debian-sys-maint user. Set up the user e.g. with:
>
>   GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost'
>   IDENTIFIED BY 'xxxxxx';
>
> and make sure that the password mentioned in /etc/mysql/debian.cnf is 
> valid.

Unfortunately this has caused problems:

mysql>  GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' 
IDENTIFIED BY 'xxxxxxxxxxxxxxxx';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
# kill `cat /var/run/mysqld/mysqld.pid`
# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used by 
Event Scheduler were found damaged at server start
ERROR 1547 (HY000) at line 1: Column count of mysql.proc is wrong. Expected 
20, found 16. The table is probably corrupted

Any idea where to go next?

It should be relatively easy to redo the user/password etc if I can get 
things running again.