I've got a WordPress site on GCP Compute Engine and a database which is hosted on Cloud SQL, which works great. My only issue is every time I select "Allow only SSL connections" on the GCP dashboard the site can't connect to the database and I get "Error connecting to database" error.
I have downloaded all the SSL (.pem) files that Google provided when creating the SQL instance. Have followed instructions by John Hanley https://github.com/jhanley-com/wordpress-cloud-sql, as soon as I turn SSL on and it still breaks.
I also have Comodo SSL for the site and Cloudflare setup, unsure if that has anything to do with it.
Have also been looking at Cloud SQL Proxy but unsure how to set that up or if it's better or worse than the above solution...
Have been instructed by John Hanley to create a new question so he can assist.
Thanks in advance.