When trying to connect from remote host to mysql server with command like this
mysql -h MySqlServerIP -u mysqlusername -p[password]
if it is taking long time. Give the following entry in /etc/my.cnf of the server
skip-name-resolve
in the [mysqld] section.
This will fix the issue. It will disable dns resolving.
No comments:
Post a Comment