MYSQL设置触发器权限问题的解决方法

ERROR 1419 (HY000): You do not have the SUPER Privilege and Binary Logging is Enabled

You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)”.

 o by specifying it on the server start, like: –log-bin-trust-function-creators=1
 o by setting it to 1 through the SET GLOBAL statement, like:
mysql> SET GLOBAL log_bin_trust_function_creators = 1;

# binary logging – not required for slaves, but remended
#log-bin=mysql-bin
# binary logging format – mixed remended
#binlog_format=mixed