mysql -u root -p -e "SHOW GRANTS FOR 'app'@'localhost';"
Show the privileges of one user
Prints every privilege the app account holds, one GRANT statement per line. The definitive answer to what an account can do before you tighten or hand out permissions.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.