[note: A broken link from a defunct blog made me dig up this post from archive.org and re-post it here; Beginners may find this informative!]
The OurSQL Podcast did an episode on some of the lesser-known but very useful tools in the Percona Toolkit. pt-show-grants is one of those tools that I use pretty frequently. While the manual page has an explanation of all the features and a few examples, you dont really see the output, and often you decide whether or not to use a tool based on what it gives you as output.
So here is a small example of an actual command I did today using pt-show-grants. I wanted to find the grants for a particular user. To do …[Read more]