Just a note, while MySQL provide a list of Version 5 Features (Official Data Sheet), I’ve so far found a few small things.
mysql> DESC [table], the Null column now shows NO when it was blank
When you grant ALL to a user, it’s gets CREATE VIEW privilege, but when upgrading, you have to manually specify the privilege for previous users that had grant ALL>
Some OUTER JOINS no longer work