mysqldump: Got error: 1042: Can’t get hostname for your address when trying to connect

If you getting error: 1042: Can’t get hostname for your address when trying to connect when trying to dump remote database using mysqldump it can be fixed by adding configuration directive:

skip-name-resolve

into section [mysqld]

Also, MySQL service should be restarted using command:

# /etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]