Hi,
Have a Google Sql instance that i can connect from not google cloud servers, and even from a local server at home. All these ip's are whitelisted.
But one of the whitelisted ip's, another server i have, doesn't connect, returning the error "ERROR 2002 (HY000): Can't connect to MySQL server on ..." after i input password.
Not sure what else to do.
Thank you for any help.
Hi @PedroIt,
Welcome to Google Cloud Community!
To troubleshoot the issue of not being able to connect to Google Cloud SQL from one specific server, you should verify that the server's IP address is whitelisted, check for firewall rules that may be blocking the connection, ensure that the MySQL client is installed and configured correctly, verify DNS resolution, and check the logs on the Cloud SQL instance. If none of these steps resolve the issue, consider reaching out to Google Cloud Support.
Thanks
Hi,
Thank you for the reply.
I've checked that the ip of the server i'm trying to connect from is in the authorized networks (like other servers that can connect to it).
I went as far as create a firewall rule to check if it was the problem, but didn't worked. Also, the other servers trying to connect to it don't have this configured and can connect.
We only have Google Cloud basic support. Not sure how to contact anyone about this. And i'm not willing to pay to what seems to be "not by mistake".
Best regards