Utilizing skip-name-resolve in MySQL.

[latifolia]

Hello there,

I want to use : skip-name-resolve in mySQL config, but it requires that all DB users to be granted with IP instead of hostname.

I can change previous created users in KH but need to modify DB user creation script so they will be granted using IP instead when they are created.

Can anyone from KH point me where to change/modify those scripts and for sure to prevent future replacement if any KH upgrades.

Regards

[Alexander]

Can you explain, what you would like to achieve?

For example using "localhost" in MariaDB/MySQL will let the database use a socket connection, which is much faster than using 127.0.0.1 which will use a TCP/IP connection.

[latifolia]

Thanks Alexander for responding.

I used tool named : https://github.com/major/MySQLTuner-perl which advised me to activate skip-name-resolve in conf. The impact thus most of accounts need to be granted by IP.

I just know that using localhost is forcing MySQL connection via socket (which surely faster).

So I guess I will stick to default KH configuration then.