How to add mysql skip name resolve

1. Add option skip-name-resolve in your config file.
2. Add cmd line option --skip-name-resolve when you start mysqld or mysqld_safe.

Edit the below metioned file and add the given code.

/etc/mysql/my.cnf OR For Ubuntu16.* /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
skip-name-resolve

And restart MySQL server using below command.

sudo service mysql restart