Utilizing skip-name-resolve in MySQL.

Locked
User avatar
latifolia
Posts: 42
Joined: Wed 18. Aug 2021, 09:08

Utilizing skip-name-resolve in MySQL.

Post by 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
User avatar
Alexander
Keyweb AG
Posts: 3810
Joined: Wed 20. Jan 2016, 02:23

Re: Utilizing skip-name-resolve in MySQL.

Post by 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.
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
User avatar
latifolia
Posts: 42
Joined: Wed 18. Aug 2021, 09:08

Re: Utilizing skip-name-resolve in MySQL.

Post by 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.
Locked