iptables drop not working

[CarltonFisk]

This IP tables command is still letting connections through other than myip:
iptables -I INPUT 1 -m state --state NEW -m tcp -p tcp -s myip/32 --dport 3306 -j ACCEPT
iptables -I INPUT 5 -m state --state NEW -m tcp -p tcp --dport 3306 -j DROP

Why isnt that working?

 

[IRudebwoy]

Why are you specifying line numbers?

Try this instead

iptables -A INPUT -p tcp -s myip/32 --dport 3306 -j ACCEPT
iptables -A INPUT -p tcp -s 0.0.0.0/0 --dport 3306 -j DROP

It appends the rules in the chain sequentially. Matching may not be needed because you're specifying TCP packets destined for the MySQL port which applies to all packets regardless of state.

Have Fun!