The solution of Ssh/mysql login slow in intranet _mysql

Often the company's development environment will be arranged in the intranet, and then there will be a common server for everyone to develop, test, so often there will be SSH connection server, or local MySQL client connection server needs, I personally experienced the company often occurs ssh/ MySQL connection to the public server is very slow, because the SSH service and MySQL service by default will be at the time of the DNS reverse parsing process, and intranet is usually not equipped with DNS services, then we can only wait for these services themselves to time out, then we can allow our login to pass, The solution is also simple, just shut down the corresponding service parsing.

The first is SSH, as follows:

/etc/ssh/sshd_config

Usedns No

Gssapiauthentication No

Gssapicleanupcredentials Yes

Next is the MySQL service:

/etc/my.ini

[Mysqld]

Skip-name-resolve

Skip-grant-tables

So that's it, reboot our SSH and MySQL service, and ssh/mysql the connection again soon.

Of course, on-line machines, we still need to open these security mechanisms.