Jesse Distad

Member
Mar 23, 2019
6
0
1
MN, USA
cPanel Access Level
Root Administrator
I'm in the process of optimizing mysql on a new server and one of the recommendations is to set skip-name-resolve=1

I have read in multiple places that doing so has caused issues on cPanel servers but those reports are not all that current, I'd like a definitive answer if this can be done without issue. I currently have bind_address set to 127.0.0.1

Will setting skip-name-resolve=1 affect accounts that have localhost set for their database connection?

thanks in advance
 

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,543
208
343
Chesapeake, VA
cPanel Access Level
DataCenter Provider
It does not break localhost connections.

I have seen errors in the backup logs with this on though but I do not believe it's actually affecting backups. But to be Frank I have not experimented much on it.

Cpanel official might have more info.