IssueTracker

Super privileges are disabled for Cloud SQL instances [1].

You are able to add a single 'sql_mode' flag by following the guide here [2]. Our engineering team is currently working on allowing multiple 'sql_mode's to be set, but there is no ETA for this.

You can find out more information on this subject on the Google Groups form here [3].

[1] https://cloud.google.com/sql/docs/features#differences
[2] https://cloud.google.com/sql/docs/mysql/flags#setting_a_title_short_flag 
[3] https://groups.google.com/forum/#!msg/google-cloud-sql-discuss/PaffwU0dVP8/A_-Eodc1AQAJ

Awesome, thank you. This worked!

Hi,

Thank you for your patience. The Cloud SQL engineering team has deployed a fix that solves the issue.

I have tested myself and now it is possible to set multiple flags from the Developers Console for the flag “sql_mode” (all the ones you mentioned). I understand that you are trying to set them using a query inside the Cloud SQL instance, but please note that that is not recommended.

Please try if you can now set the all the flags together from the Developers Console and let me know if this fix is valid for your needs.

I no longer use this product, so I will not be able to test this on your behalf

🤖 This is an automatic update. The status of the related internal issue(s) listed in "Blocked By" has changed, so we've done the following:

* Moved this issue to a locked sub-component, because the issue has been closed. Please open a new issue if you need Google to re-visit this topic.

You can read more about what these statuses mean at https://developers.google.com/issue-tracker/concepts/issues#fields