TransWikia.com

Magento 2.1 data migration SUPER privilege error

Magento Asked by randal_flagg on December 7, 2021

When running the data migration tool

php bin/magento migrate:data vendor/magento/data-migration-tool/etc/ce-to-ce/1.9.1.0/config.xml

We get the following error:

[Zend_Db_Statement_Exception]

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                                                                                                            
  BEGIN                                                                                                                                                                                                       
  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';                                 
  END   

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?

Thanks!

One Answer

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.

Answered by Franck Garnier on December 7, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP