Disable DNS (hostname) lookup for MySQL

Sindre

• April 21, 2014 04:49

Hello, I would like to start MySQL with "skip-name-resolve" to get rid of the overhead caused by the DNS lookup. However, I noticed that when adding new MySQL users in cPanel, it adds it as user@'hostname' to the grants table. This cause the authentication to fail when name resolve is disabled. Is it possible to have cPanel create the grants as @localhost or use the IP address instead? I know I can manually update the grants table, but that is not possible as users add new MySQL users all the time. Looking forward to your advise.

• 

  cPanelMichael

  • April 21, 2014 16:04

  There are no native options that would allow you to modify how the MySQL users are created through cPanel. I suggest opening a feature request, perhaps for the ability to dictate how the users are created, via: Submit A Feature Request Thank you.

  0

Please sign in to leave a comment.