So I am connection to MYSQL on SiteGround server. I need to whitelist the IP that the request is coming from to connect to the database. I took the IP address of Glitch dot com and put that in the whitelist - didn’t work.
So I looked in the log for the error and it’s giving me an IP address from AmazonWS - plus what i am finding is the IP changes every so often - so it not always the same - that is an issue with a project here that needs to connect to the database. Here is the error message:
Error: ER_ACCESS_DENIED_ERROR: Access denied for user ‘cubvox61’@‘ec2-34-239-137-159.compute-1.amazonaws.com’ (using password: YES)
As you can see the IP is 34-239-137-159 leading with ec2- always. If I white list the 34-239-137-159 all works until the IP changes again. Arg…
So how can I stop the IP from changing? Why is that happening?
Is there some way I can get all the combos of ips that might come in? I just need the first 2 digits - like the 34 above then I can whitelist 34.%