SNAKJ
By:
SNAKJ

My host can't acess to my droplet (where i've mysql db)

July 11, 2017 244 views
MySQL

I've a webhost and my BD on a droplet but since my webhost is from my university i cant get acess do my DB.

Already followed some tutorial but until now i still having the same issue over and over again.

Any help?
tks

1 Answer

Hi @SNAKJ

Have you enabled MySQL to listen on the public interface instead of just localhost?
Have you activated firewall on the droplet maybe?
Or could it be that your university has a firewall that blocks access to the database?

  • Yes i've tried everything to solve this and nothing worked, i think the problem is with my university firewall and that's kinda boring ...

    • @SNAKJ
      Run this to show listening services:

      sudo lsof -iTCP -sTCP:LISTEN -P
      

      Run this to show the status of the firewall and list entries:

      sudo ufw status
      

      And unless you have another external MySQL you can connect to from university, then I'm not sure how to test this yet.

Have another answer? Share your knowledge.