Today i created a new pod with the help of below article, attached the yaml file fyi,
https://cloud.google.com/sql/docs/mysql/connect-kubernetes-engine#6_update_your_pod_configuration_file
https://github.com/GoogleCloudPlatform/kubernetes-engine-samples/blob/master/cloudsql/mysql_wordpress_deployment.yaml ( database i pointed my privous db name)
after i deployed the 2 services, but the proxysql service has me new error Client closed local connection on 127.0.0.1:3306 ( Attached the screenshot).
From the information that you’re giving this is a bit of guess work so here’s the guess:
You’re trying to connect to localhost:3306. in your case that’d mean that you’re trying to connect to something inside the same Pod, listening on Port 3306 but there’s nothing there so the connection will be attempted to open and then closed.