mySql trigger and SUPER Privilige

[thegriff]

I am trying to add a trigger to my mySQL DB, but whether I try it from phpMyAdmin or programatically from C# in my web site, I allways get the error:

Access denied; you need the SUPER privilege for this operation

All the users I have created have full priviliges, and I use the same user fro all other database access.

CREATE TRIGGER `DeleteUser` 
AFTER DELETE ON `mylifeuser` 
FOR EACH ROW 
BEGIN 
DELETE messages.* FROM messages WHERE messages.userId=old.userId; 
DELETE accountactivity.* FROM accountactivity WHERE accountactivity.userId=old.userId;
END;

I have tried this with DELIMITER changes, with "DEFINER=" and without, I am seriously running out of ideas!
Whatever I try, it works locally either via SQLYog or programmatically, but it will not work here.
I have searched here, and via google, but no joy.

All I am trying to do is create a trigger to cascade my deletes! What am I doing wrong?

 

[Gouri]

I don't think the free hosting allowed to create triggers as per security reasons.

Staff has to confirm it.

 

[Christopher]

SUPER privileges are not available on any shared hosting accounts due to the way MySQL works.

 

[thegriff]

So I can't set triggers at all then? OK - thanks, I'll just have to do it manually!
(Wish I'd known before I spent a day on this )