SHOW GRANTS

SafeShow grants

SHOW GRANTS FOR 'user'@'host';

Lists a user's privileges — the tool for permission errors and periodic audits.

Examples

SHOW GRANTS FOR 'webapp'@'%';Audit the app user

Syntax

SHOW GRANTS [FOR 'user'@'host'];

Before you run it

Read only.

Related commands

GRANTGrant privileges
REVOKERevoke privileges

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store