Home > MySQL > Disable Remote Access for MySQL

Disable Remote Access for MySQL

March 19, 2011 Posted by KP

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



Related Posts:

Filed Under: MySQL

Comments are closed.



Archives