Access denied and SUPER privilege(s) required while importing sql dump files in Google Cloud SQL Instance

Error:

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

                                                                            OR

Solution:

While importing sql dump files in Google Cloud SQL, follow the below steps:-

1. Enter in the cloud sql instance from console by clicking on it and goto Edit configuration in the Overview tab.

2. You need to set the log_bin_trust_function_creators flag as true (i.e. on)

3. Click on Edit Configuration.

4. Click Add database flags drop down list, select log_bin_trust_function_creators                

option from the drop down list and select on.

5. Save the Cloud SQL Instance.