2015-05-17 14:50:38 1896 [Warning] Host name 'hn.kd.ny.adsl' could not be resolved: No such host is known.
2015-05-18 00:11:23 1896 [Warning] IP address '222.186.21.38' could not be resolved: The requested name is valid, but no data of the requested type was found.
2015-05-18 12:12:57 1896 [Warning] Hostname 'unassigned.psychz.net' does not resolve to '216.99.158.181'.
2015-05-18 12:12:57 1896 [Note] Hostname 'unassigned.psychz.net' has the following IP addresses:
2015-05-18 12:12:57 1896 [Note] - 199.15.112.8
2015-05-18 15:12:41 1896 [Warning] Hostname 'unassigned.psychz.net' does not resolve to '216.99.158.158'.
2015-05-18 15:12:41 1896 [Note] Hostname 'unassigned.psychz.net' has the following IP addresses:
2015-05-18 15:12:41 1896 [Note] - 199.15.112.8
2015-05-19 16:27:21 1896 [Warning] Host name 'hn.kd.ny.adsl' could not be resolved: No such host is known.
Respuesta1
Añade lo siguiente en tumy.cnf
[mysqld]
skip-host-cache
skip-name-resolve
Estas dos variables noglobalasí que necesito hacerlo service mysql restartdespués de eso
Si desea bloquear todas las conexiones al puerto 3306 (MySQL) y permitir solo aquellas que desee
$ iptables -N mysql
$ iptables -A mysql --src 1.1.1.1 -j ACCEPT
$ iptables -A mysql -j DROP
$ iptables -I INPUT -m tcp -p tcp --dport 3306 -j mysql
donde 1.1.1.1 es la dirección IP que desea agregarlista blanca