Errors when importing gen 1 v5.6 into gen 2 v5.6

[Rob]

ERROR 1227 (42000) at line 156: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Even after setting log-bin-trust-function-creators I still cannot import a simple dump from gen 1 to gen 2. Both v5.6.

How to reproduce:

1. create a db on gen 1 v5.6 with a simple trigger on a table.
2. export the gen 1 database to file X
3. import file X into gen 2 v5.6 (o v5.7, I tried both) with and without log-bin-trust-function-creators - errors out with above message.

Note that you can import and export this file all day long without errors in gen 1.

All operations performed from the browser.

Any ideas on how to get around this?

[Rob]

Without setting log-bin-trust-function-creators this is the error I get:

ERROR 1227 (42000) at line 156: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I'm pretty sure this is due to a DEFINER clause on a CREATE TRIGGER statement.

However, this *is* something that needs to be able to happen on an import. Changing the dump file is not a solution as the permissions do need to be set.

How can I work around this? Is this a bug that will be fixed?

[paynen]

Hey Rob,

Thanks for reporting this. I've been able to replicate the behaviour and I've created a Public Issue Tracker thread for this. You should star that issue to receive updates. We'll post further updates there. In general, if you find a platform issue like this, that's the place to post in future. Thanks again!

Cheers,

Nick
Cloud Platform Community Support