SQLSTATE[HY000]: General error: 1419

【SQLSTATE[HY000]: 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
SQLSTATE[HY000]: General error: 1419
文章图片

解决办法:

set global log_bin_trust_function_creators=1;

    推荐阅读