UPWORK superadmin blog

Tips and Tricks for clients

Disable dns lookups for mysql

without comments

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!

Written by spectre

December 18th, 2012 at 6:34 pm

Posted in Mysql

Leave a Reply