Show Grants for Users

Show grants for all users on a DB

SELECT CONCAT("SHOW GRANTS FOR '",user,"'@'",host,"';") FROM mysql.user;

This will return a list of all users with lines that look like this.

SHOW GRANTS FORĀ 'root'@'localhost';
SHOW GRANTS FORĀ 'motorrobot@10.22.2.%'

You can just copy and paste each line or script it out to automatically do it.