CODEWITHSUNDEEP
mysqlgoogle-compute-engine
Lakshman Pilaka
Lakshman Pilaka

Reputation: 1951

Grant Remote Access to mysql server installed on Google Compute Engine

i have followed all instructions give across google but somehow i am unable to get access from my desktop to a remote mysql database installed on Google Compute Engine.

I have done the following

a) create user and grant him permissions to get access remotely

enter image description here

b) allow the port in firewall enter image description here

c) comment out bind-address enter image description here

but still i get the error

enter image description here

when i try to connect from my remote windows client.

where i am i missing a required step??? Please help...

Upvotes: 2

Views: 2540

Answers (3)

Jacob Travis Devore
Jacob Travis Devore

Reputation: 1

Near the bottom they indicate non-compute engine access is out of scope for the article, but tells you to basically do the same stuff and set the google firewall for external access and the db user to access from outside.

Upvotes: 0

ChrisF
ChrisF

Reputation: 59

As far as I can tell, google doesn't allow remote connections to a mysql DB on cloud engine. Only between VMs, but now with an external client.

It is only allowed if you are using a dedicated Cloud SQL instance

See the first paragraph on this article (I'd be happy to be proven wrong though): https://cloud.google.com/solutions/mysql-remote-access

Upvotes: 1

PrecariousJimi
PrecariousJimi

Reputation: 1533

Ensure that you have allowed TCP traffic from your location to VM in question to port 3306 on a project level in Cloud Console or using CLI:

gcloud compute firewall-rules list

More about setting up firewalls in official documentation: https://cloud.google.com/compute/docs/vpc/firewalls

Upvotes: 0

Related Questions