CREATE USER 'hi'@'localhost' IDENTIFIED BY '1234'; GRANT TRIGGER ON schema_name.* TO 'hi'@'localhost'; SELECT * FROM information_schema.SCHEMA_PRIVILEGES WHERE grantee = "'hi'@'localhost'";