Hello Stephen,
Since you are able to connect through cloudshell using the same gcloud commands, I suspect it is an issue within your local machine. Generally, when this error is logged, it means that the Cloud SQL instance did not whitelist (authorize) your IP, but could also be an underlying networking issue. In your message, you mentioned that you can see an IP address being authorized. It could be that your true IP address is different (computer behind proxy). You may find your IP through following both scenarios in this document . Then, to isolate the issue you may try the following:
Manually add your computer's IP address in the authorization list.
use this command (gcloud uses the same client mysql command on your machine after the automatic whitelisting):
mysql -h <yourCloudSQLIP> -u root -p
More troubleshooting steps can be found here [1] [2]. Also, you may also very similar issues at stackoverflow here [3] [4] You may also try other methods to connect through this guide. I hope this helps.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/98b5ffdc-c67b-4440-a825-4600637ce720%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment