Mysql ERROR 1419 (HY000) You do not have the SUPER privilege and binary logging is enabled

July 14, 2021 . 1 MIN READ

 

ERROR 1419 (HY000) at line 2100: 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)

 

 

 

https://stackoverflow.com/questions/56389698/why-super-privileges-are-disabled-when-binary-logging-option-is-on

 

https://github.com/soundcloud/lhm/issues/76

 

 

 

mysql -u USERNAME -p

set global log_bin_trust_function_creators=1;

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *