

# Run program with -help to get a list of available options and with

# One can use all long options that the program supports. # - "~/.my.cnf" to set user-specific options. # - "/etc/mysql/my.cnf" to set global options, # The MySQL database server configuration file. REJECT all - anywhere anywhere reject-with icmp-port-unreachableĬhain ufw-user-limit-accept (0 references)Ĭhain ufw-user-logging-forward (0 references)Ĭhain ufw-user-logging-input (0 references)Ĭhain ufw-user-logging-output (0 references) LOG all - anywhere anywhere limit: avg 3/min burst 5 LOG level warning prefix " "

Ufw-logging-deny all - anywhere anywhere limit: avg 3/min burst 10Ĭhain ufw-skip-to-policy-forward (0 references)Ĭhain ufw-skip-to-policy-input (7 references)Ĭhain ufw-skip-to-policy-output (0 references)ĪCCEPT tcp - anywhere anywhere state NEWĪCCEPT udp - anywhere anywhere state NEWĪCCEPT tcp - anywhere anywhere tcp dpt:mysqlĪCCEPT udp - anywhere anywhere udp dpt:mysql RETURN all - anywhere anywhere ADDRTYPE match dst-type BROADCAST RETURN all - anywhere anywhere ADDRTYPE match dst-type MULTICAST RETURN all - anywhere anywhere ADDRTYPE match dst-type LOCAL LOG all - anywhere anywhere state INVALID LOG level warning prefix " " LOG all - anywhere anywhere limit: avg 3/min burst 10 LOG level warning prefix " "Ĭhain ufw-before-logging-input (1 references)Ĭhain ufw-before-logging-output (1 references) Ufw-logging-deny all - anywhere anywhere state INVALIDĭROP all - anywhere anywhere state INVALIDĪCCEPT icmp - anywhere anywhere icmp destination-unreachableĪCCEPT icmp - anywhere anywhere icmp source-quenchĪCCEPT icmp - anywhere anywhere icmp time-exceededĪCCEPT icmp - anywhere anywhere icmp parameter-problemĪCCEPT icmp - anywhere anywhere icmp echo-requestĪCCEPT udp - anywhere anywhere udp spt:bootps dpt:bootpcĪCCEPT udp - anywhere 224.0.0.251 udp dpt:mdnsĪCCEPT udp - anywhere 239.255.255.250 udp dpt:1900Ĭhain ufw-before-logging-forward (1 references) Ufw-user-forward all - anywhere anywhereĪCCEPT all - anywhere anywhere state RELATED,ESTABLISHED LOG all - anywhere anywhere LOG level warning prefix " "Ĭhain ufw-after-logging-input (1 references)Ĭhain ufw-after-logging-output (1 references) Ufw-skip-to-policy-input all - anywhere anywhere ADDRTYPE match dst-type BROADCASTĬhain ufw-after-logging-forward (1 references) Ufw-skip-to-policy-input udp - anywhere anywhere udp dpt:bootpc Ufw-skip-to-policy-input udp - anywhere anywhere udp dpt:bootps Ufw-skip-to-policy-input tcp - anywhere anywhere tcp dpt:microsoft-ds Ufw-skip-to-policy-input tcp - anywhere anywhere tcp dpt:netbios-ssn Ufw-skip-to-policy-input udp - anywhere anywhere udp dpt:netbios-dgm Ufw-skip-to-policy-input udp - anywhere anywhere udp dpt:netbios-ns Ufw-reject-output all - anywhere anywhere Ufw-after-logging-output all - anywhere anywhere Ufw-before-output all - anywhere anywhere Ufw-before-logging-output all - anywhere anywhere Ufw-reject-forward all - anywhere anywhere Ufw-after-logging-forward all - anywhere anywhere Ufw-after-forward all - anywhere anywhere Ufw-before-forward all - anywhere anywhere Ufw-before-logging-forward all - anywhere anywhere Ufw-after-logging-input all - anywhere anywhere Ufw-before-logging-input all - anywhere anywhere I hope I didn't forget to pass along any other relevant information. So my question here is how would I establish a connection between Raspberrys MySQL server and my work computer's client MySQLWorkbench without using SSL and SSH as simple as possible, so I could get back to working with PHP? I've copied the content of my.cnf file and iptables -L output. SSH(22) works and so does HTTP(80), but 3306 won't budge. I can't connect to MySQL server on Raspberry. I have a feeling something is overriding the user input rules, maybe something I have added to iptables? It took me two days of playing around with iptables to find Uncomplicated Firewall, which seems straight forward enough, but I can't get it to work nonetheless. It has a static IP and so does my OSX work computer I have a RaspberryPi 2 with RaspbianOS on my local network (192.168.0.0/24).
