MySQL Privileges required to GRANT EVENT, EXECUTE, LOCK TABLES, and TRIGGER
- by Brad
I have an account, user_a, and I would like to grant all available permissions on some_db to user_b. I have tried the following query:
GRANT
ALTER, ALTER ROUTINE,
CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW,
DELETE, DROP, EVENT, EXECUTE,
INDEX, INSERT, LOCK TABLES,
REFERENCES, SELECT, SHOW VIEW,
…