MySQL @ 3:00 AM

So here is what I learned while working with MySQL at 3:00 am

1. usernames have to be 16 characters or less.  30 minutes lost rebooting a mysql server.
2. Triggers have a "definer" that specifies the security context the trigger is run in.  So when restoring a database if that user doesn't exist you will run into problems.  That I could find there isn't an easy programmatic way to reset the definer of a trigger.  Presumably you could remove and recreate the trigger, but doing that is a pain in the ass too.