mysql -e "SHOW GRANTS FOR 'alice'@'localhost';"

Category: Databases & SQL

mysql -e "SHOW GRANTS FOR 'alice'@'localhost';"

Show a user's granted privileges

Lists every privilege the account holds and where it applies. Useful before and after GRANT or REVOKE. Related: GRANT ALL PRIVILEGES.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.