Bug #84002 Cannot override skip-name-resolve in my.cnf

• Submitted: 29 Nov 2016 9:33
• Modified: 2 Dec 2016 13:29
• Reporter: Roberto Polli
• Status: Verified
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 5.7, 5.6.34, 5.7.16
• OS: Any
• CPU Architecture: Any

[29 Nov 2016 9:33] Roberto Polli

Description:
If my.cnf contains skip-name-resolve, it's impossible to override it by command line.

See this issue in the mysql docker image.

https://github.com/docker-library/mysql/issues/154#issuecomment-236276126

How to repeat:
Reproduce:

  1 - add 'skip-name-resolve' in my.cnf
  2- run without skip-name-resolve

   mysqld --skip-name-resolve=OFF

I expect:

  skip-name-resolve=OFF

Instead:
  
  skip-name-resolve=ON

Suggested fix:
Read skip-name-resolve variable from commandline and override my.cnf settings.

[2 Dec 2016 13:29] MySQL Verification Team

Hello Roberto,

Thank you for the report.

Thanks,
Umesh