Can't connect to MySQL server via HTTP/HTTPS

December 3, 2017 125 views
DigitalOcean Firewall IPv6 Ubuntu 16.04

I have my app connected to the database and when I try to request info I get this: sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1130, "Host '<router>' is not allowed to connect to this MySQL server").

Also when I connect to my Droplet via SSH I get this: The UFW firewall is enabled. All ports execpt for SSH, HTTP/HTTPS and MySQL
are blocked by default.

How can I change this so my app can connect to the database? I need HTTP/S

Be the first one to answer this question.