关于magento2:SQLSTATEHY000-General-error-1419

报错:
magento2SQLSTATE[HY000]: General error: 1419 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), query was: DROP TRIGGER IF EXISTS trg_catalog_category_entity_after_insert

解决办法:

set global log_bin_trust_function_creators=1;