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 🙂

Recording: https://youtu.be/D7jXVYFHI5A

Slides: Advanced User Permissions

Here is a PDF Version of the slides: Advanced User Permissions