Disable dns lookups for mysql

In a small environment VPS or VDS, there’s very little reason to rely on DNS resolution inside MySQL.
You can disable it by adding ‘skip-name-resolve’ to your my.cnf (section mysqld) or by using the ‘–skip-name-resolve’ command line argument. Remember: If you disable DNS lookups, you will need to set permissions using IP addresses rather than host names!

Scroll to top