When I try to create a trigger on a table, I encounter the following error:
#1227 - Access denied; you need the SUPER privilege for this operation
Does anyone know of a way around this? Or is trigger creation a futile endeavor?
You are the first to ask about it (at least that I remember). I've checked it out and it seems that an upgrade to MySQL 5.1 is needed for it, and maybe I'll need to manually add the permission to your database user (I'm not sure).
Unfortunately I don't have much time at the moment and a mysql upgrade will probably have to wait for a month or so unfortunately.
I read up a bit on the MySQL docs too, and I think you're right that an upgrade is necessary. Granting the SUPER privilege is too dangerous for such a simple request. Please keep us posted on upgrade plans! Thank you.
I upgraded MySQL (and some other stuff) on server 4. Please check if it works now, otherwise I'll check if extra permissions are needed.
Thanks a lot, Bondings! I can now create and drop triggers in my database. You're way faster than most support teams I've dealt with in my professional experience.
Regarding the privileges thing, while I understand why users shouldn't be allowed to modify permissions, I think it would make sense for the user who "owns" the database to be able to do everything that pertains to that specific database.
But most importantly, thanks again for your flash-fast help!