When running the data migration tool

php bin/magento migrate:data vendor/magento/data-migration-tool/etc/ce-to-ce/

We get the following 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_compare_item_after_insert AFTER INSERT ON catalog_compare_item FOR EACH ROW                                                                                                            
  INSERT INTO m2_cl_catalog_compare_item (`catalog_compare_item_id`, `operation`) VALUES (NEW.catalog_compare_item_id, 'INSERT')ON DUPLICATE KEY UPDATE operation = 'INSERT';                                 

Unfortunately, as we are on a Shared Server they cannot provide this privilege or configure this variable from the hosting's end.

Is there something we can change to make this work?


  • Have you checked the privilage of your db username in the server backend (CPanel or anything else? Does it includes trigger? Have you tried to run this in shell : mysql -u USERNAME -p (your password) and then run set global log_bin_trust_function_creators=1;
    – Marbonka
    Mar 20, 2020 at 19:01

1 Answer 1


You may try to set the MySQL variable directly on the MySQL client.

set global log_bin_trust_function_creators=1;

If not, you need to check with your hosting provider.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.