Aaron,
For MySql 5.5, SUPER privilege is not enough to create/drop triggers. The user must have 'TRIGGER' permissions or 'ALL PRIVELEGE'.
Before MySql 5.1.6, the 'TRIGGER' permission did not exist and the user had to have 'SUPER' permissions.
Do we want to make MySql 5.1.6 the minumum supported version?
Ghada
Aaron,
For MySql 5.5, SUPER privilege is not enough to create/drop triggers. The user must have 'TRIGGER' permissions or 'ALL PRIVELEGE'.
Before MySql 5.1.6, the 'TRIGGER' permission did not exist and the user had to have 'SUPER' permissions.
Do we want to make MySql 5.1.6 the minumum supported version?
Ghada