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:
- MySQL Optimization
- Optimizing MySQL
- MySQL Start Script
- Monitor MySQL Log File
- MySQL Backup and my.cnf
- MySQL Log File
- Install a Proxy Server – Privoxy
- Create MySQL User
Filed Under: MySQL