SQL trigger won't execute -

the following trigger won't execute in heidisql or phymyadmin, assistance gretly appreciated in fixing.

i'm using heidisql, , used workbench. though shouldn't matter

delimiter $$ create trigger t_l_in_a     before update on x_l    each row begin    if old.in_a = 1        set new.status = 0;    end if; end$$ delimiter; 

assuming table names , col names correct.

thanks much.

ps. error: sql error (1419): not have super privilege , binary logging enabled (you might want use less safe log_bin_trust_function_creators variable)

i using admin user db,

as using amazon ews answered question: https://techtavern.wordpress.com/2013/06/17/mysql-triggers-and-amazon-rds/