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. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/jaughj$5l9$1...@dough.gmane.org
