I’ve built a mySQL database on Google Cloud using my locally installed WorkBench. ( no problem connecting to the database from my PC)
However I now want my app on Glitch to connect to it. I’m using this JS code to connect to my database hosted on Google cloud
const mysql = require(‘mysql’);
var con = mysql.createConnection({
host: process.env.SERVER,
database: process.env.DATABASE_NAME,
user: process.env.USER_NAME,
password: process.env.PASSWORD
});
con.connect(function(err) {
if (err) throw err;
console.log("Connected!");
});
I’ve double checked that my env file holds all the correct values
In order for Google to allow a connection I have to specify the public IP that will be attempting the connection.
What Glitch ip address should I use for me to add Glitch to Google’s whitelist?
Open up the glitch console and run this curl whoami.computer
, that should give you Glitch’s ip address 
The issue with that is that Glitch container IPs change from time to time. If you plan on using Glitch for the long run, you should be prepared to whitelist a new IP from time to time.
1 Like
Nice one - That worked a treat
I was using the iP address derived from my shared Glitch URL - https://necessary-stump-****.glitch.me
I completely different IP address which would explain why it wasn’t working for me.
And I accept this solution isn’t cast in stone and That I will need to periodically update the IP address as and when the issue returns.
I hope this helps others who are travelling a similar path . . .
1 Like
you could use 0.0.0.0 , but that whitelists every address
0.0.0.0
is an internal address, no?
1 Like
In MongoDB you can do 0.0.0.0/0 or something to whitlelist all ips
3 Likes
I mean you could as Glitch for every IP they are using.
This
would be the ideal solution and the IP to whitelist.
2 Likes

Works a treat but comes with a warning as already discussed
3 Likes
If you are going to whitelist all ips, you should be sure to make a strong password.
2 Likes
Unless you are constantly logging into it. I would recommend to make the pssword a sha526 has.
You mean a sha512
or a sha256
hash?