ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
After moving a complete SQL dump from a MySQL 5.0 server to a MySQL 5.1 server I forgot about any issues stemming from the different versions of MySQL. Importing the old information_schema tables and any possible changes for the mysql table itself made it barf out the error message “ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used by Event Scheduler were found damaged at server start” when trying to connect to the server.
The connection were still made, but obviously something were afoot. A few pages hinted in the direction of using mysql_upgrade to upgrade the now 5.0-compatible tables to the 5.1 format, but mysql_upgrade didn’t seem to want to run (maybe because of a new root password / debian-sys-maint password). The solution was to tell mysql_upgrade to ask for a password, which user it should connect as and which server it should connect to. You should run this command as root (preferrably through sudo) so that it can run mysql_fix_privilege_tables with the correct permissions:
-
sudo mysql_upgrade -u root -h localhost -p –verbose –force
The --force parameter will make the command run even if it thinks your server already has been upgraded to 5.1 (or the current version if you’re reading this at a later time). It may think this if you’ve already performed parts of the upgrade, but failed when trying to do the mysql_fix_privilege_tables-bit.
And away we went!
Tags: MySQL, mysql5.0, mysql5.1, mysql_upgrade, repair
June 13th, 2010 at 17:15
worked, thanks. just need two dashes on –verbose –force
June 13th, 2010 at 21:40
Oh, sorry. That’s wordpress fubaring things up. Doesn’t seem like I can do very much about it without actually changing the wordpress code itself..
August 23rd, 2010 at 02:23
Thanks man, worked like a charm.
September 30th, 2010 at 14:26
TQ, works well ;)
October 12th, 2010 at 00:23
Worked beautiful mate, thanks a lot for your help!
Wish you well,
Dan
January 4th, 2011 at 12:20
Thanks, that work good, and saved me a lot of time.
KFB
June 16th, 2011 at 05:55
Cheers for that one, just bumped into the same issue when upgrading to Percona 5.5.
September 19th, 2011 at 15:52
Thanks a lot Mats! This is the second time today you save my day!
December 18th, 2011 at 21:10
Works fine, thx !!!
December 22nd, 2011 at 19:31
Thanks! That fixed ‘er right up!
January 25th, 2012 at 08:59
And at least with Debian Squeeze to be “–force” the very first parameter in line!
February 21st, 2012 at 07:21
That was exactly what I needed! By the way, Debian Squeeze does not require –force to be the first parameter.
April 13th, 2012 at 03:06
Don’t forget to restart MySQL after running mysql_upgrade!
May 12th, 2012 at 13:01
[...] have to say big thanks to Mats Lindth wonderful blog post which provided me with the [...]
June 29th, 2012 at 15:48
Thanks a lot, lost TWO days behind this migration. And you solved all that in seconds.
Thanks again :-)
July 27th, 2012 at 09:30
[...] an Mats Lindh Dieser Eintrag wurde veröffentlicht in LINUX und verschlagwortet mit ERROR 1577 (HY000) at line [...]
January 11th, 2013 at 14:35
After search in google, this was first.
SOLVED SUCESSFULL!
Thanks.
April 22nd, 2013 at 15:45
Hi, you made my day too ;-)
Thanks.
(was after moving 5.0 mysql schemas to a brand new install of v5.1 from squeeze, so I had reimported old system shcemas into mysql, explaining the need for running the update script)