Re: Fixing corrupt mysql table

2011-11-27 Thread Robert S
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 'xx'; and make sure that the password mentioned in /etc/mysql/debian.cnf is valid. Unfortunatel

Re: Fixing corrupt mysql table

2011-11-27 Thread Robert S
Thanks. After backing up the entire system here's what I get when I try to reconfigure mysql: # dpkg-reconfigure mysql-server-5.1 Stopping MySQL database server: mysqld. Stopping MySQL database server: mysqld. 28 12:43:41 [Note] Plugin 'FEDERATED' is disabled. 28 12:43:41 InnoDB: Star

Re: Fixing corrupt mysql table

2011-11-27 Thread Karl E. Jorgensen
On Sun, Nov 27, 2011 at 05:26:52PM -0500, Robert S wrote: > I recently rebooted my server and mysql didn't start - it reported password > problems. I have reset the root password but there are other errors: > > # /etc/init.d/mysql start > Starting MySQL database server: mysqld. > Checking for co

Re: Fixing corrupt mysql table

2011-11-27 Thread Bob Proulx
Robert S wrote: > Subject: Re: Fixing corrupt mysql table > I recently rebooted my server and mysql didn't start - it reported > password problems. I have reset the root password but there are > other errors: > > # /etc/init.d/mysql start > Starting MySQL database serv

Re: Fixing corrupt mysql table

2011-11-27 Thread Walter Hurry
On Mon, 28 Nov 2011 09:26:52 +1100, Robert S wrote: > I recently rebooted my server and mysql didn't start - it reported > password problems. I have reset the root password but there are other > errors: > > # /etc/init.d/mysql start Starting MySQL database server: mysqld. > Checking for corrupt,

Fixing corrupt mysql table

2011-11-27 Thread Robert S
I recently rebooted my server and mysql didn't start - it reported password problems. I have reset the root password but there are other errors: # /etc/init.d/mysql start Starting MySQL database server: mysqld. Checking for corrupt, not cleanly closed and upgrade needing tables.. ERROR 1045 (28