My store is in AWS lightsail largest server tier.
Exported DB from localserver to its own external server, connect with M2 = works like a charm. Later wanted to install an extension and when type in CLI setup upgrade getting this error:
SQLSTATE[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: CREATE TRIGGER trg_catalog_category_product_after_insert AFTER INSERT ON catalog_category_product FOR EACH ROW BEGIN INSERT IGNORE INTO catalogrule_product_cl ( entity_id ) VALUES (NEW. product_id ); END
spent many days researching and found nothing. am not expert in Mysql obviously but I understand is something about permissions… any idea?
my thoughts are:
my M2 is based on craigs tutorial. so I have an user with permissions for magento2 inside the /html folder. aws logs you in with ubuntu user. so am not sure if just changing the user to perform the export have to do with this? the weird thing is, the DB works perfectly. is just I can’t do the commands setup:upgrade. with my M2 user.