Related

Product Now Available: Managed MySQL Databases Product
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question

Question

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

Posted July 11, 2017 1.7k 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

Add a comment
SNAKJ
By:
SNAKJ
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer
hansen July 11, 2017

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?

Reply Report
  • SNAKJ July 11, 2017

    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 …

    Reply Report
    • hansen July 11, 2017

      @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.

      Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help