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
Utilizing skip-name-resolve in MySQL.
Re: Utilizing skip-name-resolve in MySQL.
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.
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
**************************************************************
Alexander Mahr
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Re: Utilizing skip-name-resolve in MySQL.
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.
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.