Restricting MySQL 3306 port with IPTABLES

mysql security centos firewall iptables
Putra Fajar Hasanuddin picture Putra Fajar Hasanuddin · Mar 10, 2014 · Viewed 12.3k times · Source

How to block mysql port 3306 for everybody, but allow it for a specific IP? This is what I currently do:

iptables -I INPUT 1 -p tcp --dport 3306 -j ACCEPT

Answer

peterh - Reinstate Monica picture peterh - Reinstate Monica · Mar 10, 2014

You need multiple rules to do that. In most cases, what will happen with a connection depends on the first rule, which it matches. So, first we accept our friends connection, second, we drop anybody other. Voila!

iptables -I INPUT 1 -p tcp -s 1.2.3.4 --dport 3306 -j ACCEPT
iptables -I INPUT 2 -p tcp --dport 3306 -j DROP

Related questions

How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
SQL injection that gets around mysql_real_escape_string()

Is there an SQL injection possibility even when using mysql_real_escape_string() function? Consider this sample situation. SQL is constructed in PHP like this: $login = mysql_real_escape_string(GetFromPost('login')); $password = mysql_real_escape_string(GetFromPost('password')); $sql = "…

Read More
How to secure phpMyAdmin

I have noticed that there are strange requests to my website trying to find phpmyadmin, like /phpmyadmin/ /pma/ etc. Now I have installed PMA on Ubuntu via apt and would like to access it via webaddress different from /phpmyadmin/. What …

Read More