Bug #73488 Documentation: skip_name_resolve variable effect is misleading

• Submitted: 6 Aug 2014 16:03
• Modified: 12 Aug 2014 10:21
• Reporter: Jeff Jirsa
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.6
• OS: Any
• Assigned to: Jon Stephens
• CPU Architecture: Any

[6 Aug 2014 16:03] Jeff Jirsa

Description:
The documented effect of the skip_name_resolve / skip-name-resolve variable is incorrect at http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_skip_name_resol... : 

The stated behavior:
Default	OFF
This variable is set from the value of the --skip-name-resolve option. If it is ON, mysqld resolves host names when checking client connections. If OFF, mysqld uses only IP numbers and all Host column values in the grant tables must be IP addresses or localhost. See Section 8.11.5.2, “DNS Lookup Optimization and the Host Cache”.

Is actually the reverse (which is confirmed in other parts of the manual, such as http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_skip-name-resolve ) 

The skip-name-resolve does default to OFF. In the OFF state, mysqld resolves host names when checking client connections. If ON,  mysqld uses only IP numbers and all Host column values in the grant tables must be IP addresses or localhost.

How to repeat:
Documentation bug. Please read http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_skip_name_resol....

Suggested fix:
Change wording:

In the OFF state, mysqld resolves host names when checking client connections. If ON,  mysqld uses only IP numbers and all Host column values in the grant tables must be IP addresses or localhost.

[7 Aug 2014 8:30] MySQL Verification Team

Hello Jeff Jirsa,

Thank you for the bug report.

Thanks,
Umesh

[12 Aug 2014 10:21] Jon Stephens

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.