[FIX] Access denied; you need (at least one of) the SUPER privilege(s) for this operation [ AMAZON RDS ]

mysqldump generate trigger

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`%`*/ /*!50003 TRIGGER `after_insert_lead` AFTER INSERT ON `leads` FOR EACH ROW BEGIN
UPDATE analytics.mapping SET id_lead = NEW.id_lead WHERE mc_email = NEW.email;
END */;;
DELIMITER ;
find him!!!!

cat yourDB | grep DEFINER= | less

so finish HIM!! remove DEFINER
just do it

perl -pe 's/\sDEFINER=`[^`]+`@`[^`]+`//' < oldfile.sql > newfile.sql
 
 
or with source
mysql > source /path/your/file.sql
 
source 
source2 

Comments

Popular Posts