Re: Fixing corrupt mysql table
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, not cleanly closed and upgrade needing tables..
> ERROR 1045 (28000): Access denied for user
> 'debian-sys-maint'@'localhost' (using password: YES)
>
> When I get into phpmyadmin and go to the "Privileges" tab I get the
> following:
>
> SQL query:
> (SELECT `User`, `Host`, `Select_priv`, `Insert_priv`, `Update_priv`,
> `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `Index_priv`,
> `Alter_priv`, `References_priv`, `Create_tmp_table_priv`,
> `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`,
> `Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`,
> `Event_priv`, `Trigger_priv`, `Db` FROM `mysql`.`db` WHERE 'contacts'
> LIKE `Db` AND NOT (`Select_priv` = 'N' AND `Insert_priv` = 'N' AND
> `Update_priv` = 'N' AND `Delete_priv` = 'N' AND `Create_priv` = 'N' AND
> `Drop_priv` = 'N' AND `Grant_priv` = 'N' AND `References_priv` = 'N' AND
> `Create_tmp_table_priv` =
> 'N' AND `Lock_tables_priv` = 'N' AND `Create_view_priv` = 'N' AND
> `Show_view_priv` = 'N' AND `Create_routine_priv` = 'N' AND
> `Alter_routine_priv` = 'N' AND `Execute_priv` = 'N' AND `Event_priv` =
> 'N' AND `Trigger_priv` = 'N')) UNION (SELECT `User`, `Host`,
> `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`,
> `Create_priv`, `Drop_priv`, `Grant_priv`, `Index_priv`, `A[...]
>
> MySQL said:
> #1054 - Unknown column 'Event_priv' in 'field list'
>
> I have run myisamchk and myisamchk -r on all of the databases.
>
> Will it be necessary to rebuild everything from scratch?
>
> I've got a lot of it running temporarily by using the root user and
> password in a few scripts but how can I restore the system?
Wrong list. Try a MySQL list.
Reply to: