Article ID: 124714, created on Mar 3, 2015, last review on Mar 3, 2015

  • Applies to:
  • Odin Business Automation Standard

Symptoms

There are warnings in /var/log/mysqld.log like

150303 23:33:39 [Warning] 'user' entry 'root@hspc.domain.tld' ignored in --skip-name-resolve mode.
150303 23:33:39 [Warning] 'user' entry '@hspc.domain.tld' ignored in --skip-name-resolve mode.
150303 23:33:39 [Warning] 'user' entry 'aspcomplete@hspc.domain.tld' ignored in --skip-name-resolve mode.
150303 23:33:39 [Warning] 'user' entry 'aspcsk@hspc.domain.tld' ignored in --skip-name-resolve mode.
150303 23:33:39 [Warning] 'user' entry 'aspcss@hspc.domain.tld' ignored in --skip-name-resolve mode.
150303 23:33:39 [Warning] 'user' entry 'aspsession@hspc.domain.tld' ignored in --skip-name-resolve mode.
150303 23:33:39 [Warning] 'db' entry 'aspc aspcomplete@hspc.domain.tld' ignored in --skip-name-resolve mode.
150303 23:33:39 [Warning] 'db' entry 'aspc_mutex aspcomplete@hspc.domain.tld' ignored in --skip-name-resolve mode.
150303 23:33:39 [Warning] 'db' entry 'sk aspcsk@hspc.domain.tld' ignored in --skip-name-resolve mode.
150303 23:33:39 [Warning] 'db' entry 'ss aspcss@hspc.domain.tld' ignored in --skip-name-resolve mode.
150303 23:33:39 [Warning] 'db' entry 'dbsession aspsession@hspc.domain.tld' ignored in --skip-name-resolve mode.

Cause

The skip-name-resolve option is enabled in /etc/my.cnf

Resolution

Comment out skip-name-resolve and restart mysqld service.

Search Words

/etc/my.cnf

skip-name-resolve

ignored in --skip-name-resolve mode

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF