Permissions for creating a trigger in mysql

Question

mysql ver is 5.0.67

my trigger code is :

DELIMITER //
CREATE TRIGGER upd_price BEFORE UPDATE ON product_price
 FOR EACH ROW BEGIN  
    INSERT INTO update_price_log (product_id, product_price_old, product_price_new) values(OLD.product_id, OLD.product_price, NEW.product_price);
END
//
DELIMITER ;

error is:

#1227 - Access denied; you need the SUPER privilege for this operation

my server, is not cpanel! it is : DirectAdmin Web Control Panel.

how can i create SUPER privilege and create my trigger?

Answer 1

Another way to create trigger without SUPER privilege by adding the following line to my.cnf or my.ini log_bin_trust_function_creators = 1

Answer 2

I tried to give SUPER privilede on database.table level, but it fails, so I did

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

then created my triggers. But don't forget to revoke it

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

Because it's a dangerous privilege to leave it granted in internet database