phpMyAdmin 3.2.4 error #1227 - Access denied; you need the SUPER privilege for this operation
Posted
by CheeseConQueso
on Stack Overflow
See other posts from Stack Overflow
or by CheeseConQueso
Published on 2010-05-14T01:55:18Z
Indexed on
2010/05/14
2:04 UTC
Read the original article
Hit count: 1192
I want to make a simple sql trigger on inserts... something like this
CREATE TRIGGER filter
AFTER INSERT
ON table
FOR EACH ROW
DELETE FROM table
WHERE field LIKE "%chicken%"
OR field LIKE "%egg%";
After running it through phpMyAdmin 3.2.4 & MySQL 5.0.45 you get an error that says
#1227 - Access denied; you need the SUPER privilege for this operation
Is this syntax wrong or do I have to change something else to get past this error?
© Stack Overflow or respective owner
