MySQL asking a user for SUPER privilege to perform a delete.
- by Fran
Hello,
When trying to do a delete operation on a table, mysql reports the following error:
Error code 1227: Access denied; you need the SUPER privilege for this operation.
However, my user has this privilege granted for all tables in the schema:
GRANT ALL PRIVILEGES ON myschema.* TO 'my_admin'@'%'
How come it asks me for SUPER privilege for a delete?
Thanks in advance.