I was trying to use workbench for mysql
I did the following
sudo iptables -I INPUT -p tcp -m tcp --dport 3306 -j ACCEPT
sudo iptables-save | sudo tee /etc/iptables/rules.v4
However, it doesn't work... it does not connect (from workbench)
I also think that is not a secure connection... maybe I need to use ssl?
My rules.v4 looks like this
Generated by iptables-save v1.4.14 on Tue Sep 24 16:38:30 2013
:INPUT ACCEPT [87:7016]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [74:6968]
-A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT
# Completed on Tue Sep 24 16:38:30 2013
However, I notice that 3306 is already open based on this file, before -A INPUT (in :INPUT ACCEPT)
or do I have to create a VPN to have a more secure connection?
I would like to be able to use mysql workbench
By the way, I'm running MariaDB on Debian 7 64 bits
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.