Dear All,
we are testing the Google Cloud features and services in order to migrate our infrastructure on Google.
We are testing the SQL service, but during the import we have some problems with this error:
- Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Searching for a possible solution we tried to set the flag:
log_bin_trust_function_creators => OnWe tried to disable the binary logging and remove replicas, but nothing, we have the same problem:
ERROR 1227 (42000) at line 71: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
The lines are similar to:
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `deleteVideoInSpace` BEFORE DELETE ON `tbl_ugvideos` FOR EACH ROW UPDATE tbl_spaces
or:
/*!50001 CREATE ALGORITHM=UNDEFINED */
any ideas?
thank you in advance