MySQL user privileges

Check privileges

Check privileges for self:

SHOW GRANTS;

Check privileges user:

SHOW GRANTS FOR 'username'@'host'; 

Example output:

GRANT TRIGGER ON `schema`.* TO `username`@`%`
GRANT SELECT, INSERT, UPDATE, TRIGGER ON `schema`.`table` TO `username`@`%`

https://www.prisma.io/dataguide/mysql/authentication-and-authorization/privilege-management

Grant

Revoke