I am unable to connect to my SQL instance just following what you have provided. I see you used socket from local host but on cloud function you did not use the socket part. I get the following error pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'w.x.y.z' (timed out)") My SQL instance has a public and private IP. Should I use sockets even on the cloud, or maybe sql proxy? service account is as you ve shown with the right level of permissions.
If it fails on the Cloud functions make sure you enable Cloud SQL Admin API. If the proxy fails on your local machine make sure the user you are using has permissions for Cloud SQL and you enter the password correctly. You can go to IAM in Google Web Console and give "Cloud SQL Admin" to the user you logged in with
I want to connect to my instance in a project I have deployed on google server. I am scrapping data and I want to store the data in this instance. How do I do that? Can you spare me few minutes? I will provide my contact details.
@@vladsavecoding4111 thank you for replying, but can you make a tutorial where in you use a machine running on windows? because I somehow cannot follow this video since its on mac