https://dev.mysql.com/doc/refman/8.0/en/show-grants.html SHOW GRANTS Statement SHOW GRANTS [ FOR user_or_role [ USING role [ , role ] . . . ] ] user_or_role : { user ( see Section 6.2 . 4 , “Specifying Account Names ” ) | role ( see Section 6.2 . 5 , “Specifying Role Names ” . } This statement displays the privileges and roles that are assigned to a MySQL user account or role, in the form of GRANT statements that must be executed to duplicate the privilege and role assignments. Note To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER statement. See Section 13.7.7.12, “SHOW CREATE USER Statement” . SHOW GRANTS requires the SELECT privilege for the mysql system schema, except to display privileges and roles for the current user. To name the account or role for SHOW GRANTS , use the same format as for the GRANT statement (for example,...