Permissions for creating a trigger in mysql (normal user)

create trigger without SUPER privilege by adding the following line to my.cnf or my.ini    

 log_bin_trust_function_creators = 1

OR 

Give SUPER privilege on database 

grant super on *.* to 'honni'@'localhost';

revoke it

revoke super on *.* from 'my_user'@'localhost';