We need to turn the general log

[Vishva Kumara]

Two of out projects are experiencing a serious problem and we need to log all SQL queries. For this we need to enable the mysql general log. But this needs Super privileges.

Please help us getting this sorted out. I hope someone from support team can contact me.

Thank you.

[Digil (Google Cloud Platform Support)]

Currently,  Cloud SQL ‘does not’ support SUPER privileges. However, there is a feature request in place to support it. You should be able to configure database flags including general_log as one of the supported flags for Cloud SQL, without having the SUPER privileges. Make sure that you have necessary access control towards the Google Cloud Platform resources as well.  

[Brett Hesterberg]

Cloud SQL logs are sent to Stackdriver Logging, where they can be viewed in the Console and retrieved via API.  To enable database logging in Cloud SQL, please follow these steps.  For example, to enable general query logging (set slow_query_log flag to 'On') and enable logging to Stackdriver Logging (set log_output flag to 'File') on their Cloud SQL instance.

[Vishva Kumara]

Thank you very much. I could set the flag and looking forward to the logs :-)

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/da540000-f6cd-4bd6-9e8d-414cf42a8a74%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Vishva Kumara