At a recent (the first) Arizona MySQL Professionals Meetup I gave a presentation on Advanced User Grants. Below you will find links to the video (poor quality recordings will improve) and the slides.
Hope you find it useful 🙂
Slides: Advanced User Permissions
Here is a PDF Version of the slides: Advanced User Permissions