I am trying to make my database available on the internet so I hosted my database on Google Cloud Platform. With their instructions, I am able to connect with my public IP address to access the remote database with my MySQL Workbench & make request with the database public IP address.

However, I realize that my IP could change because public IP is different on every network, which may mean my database is stuck on the local computer environment. What should I do to make the database available to all networks? I want thrid party users to use my api to get data from my remote database.

I am not sure putting the server on the internet is what a developer supposed to do, just trying to get things out of localhost but I am very confused. Please help me :)

The problem (I think)

Public IP changes on different router, cutting off my database connection.

CodePudding user response：

You can add all public-ip range into your "Authorized networks"

Add 0.0.0.0/0 as allowed CIDR for IPv4