MySQL 로그파일에 어제부턴가 아래와 같은 에러메세지가 쌓였다.

110502 21:25:50 [Warning] IP address '211.154.154.171' could not be resolved: no reverse address mapping.
110502 21:25:50 [Warning] IP address '211.154.154.171' could not be resolved: no reverse address mapping.
110503 16:16:30 [Warning] IP address '123.108.110.132' could not be resolved: no reverse address mapping.
110505  8:48:18 [Warning] IP address '178.86.2.128' could not be resolved: no reverse address mapping.
110506 12:46:43 [Warning] IP address '61.251.180.155' could not be resolved: no reverse address mapping.
110508  9:44:27 [Warning] IP address '27.122.56.198' could not be resolved: no reverse address mapping.
110508 20:33:47 [Warning] IP address '220.149.130.192' could not be resolved: no reverse address mapping.
110509 10:01:21 [Warning] IP address '222.124.214.134' has been resolved to the host name '134.subnet222-124-214.static.astinet.telkom.net.id', which resembles IPv4-address itself.
110509 10:30:13 [Warning] IP address '190.80.203.22' has been resolved to the host name '22.203.80.190.m.sta.codetel.net.do', which resembles IPv4-address itself.
110509 10:30:17 [Warning] IP address '210.193.59.43' has been resolved to the host name '43.210-193-59.static.qala.com.sg', which resembles IPv4-address itself.

Disable Remote Access for MySQL

I’m seeing messages like below in mysql error log on my new server:

110318 10:48:02 [Warning] IP address ‘x.x.x.x’ could not be resolved: no reverse address mapping.

I don’t need to access mysql remotely, it should be disabled for either performance or security. This can be changed by adding “skip-networking” in my.cnf, mysql will not listen on a TCP/IP port at all.

[mysqld]
skip-networking

위의 대처법으로 해결 되었으면 좋게다. 몇일 모니터링 해 보면 알겠지.