You are here
Warning user entry ignored in MySQL error log
Sun, 2014-12-28 15:30 — oli
Hello all,
I am getting some MySQL warnings in the error log during the start-up:
[Warning] 'user' entry 'root@master' ignored in --skip-name-resolve mode. [Warning] 'proxies_priv' entry '@ root@laptop4' ignored in --skip-name-resolve mode.
Please suggest how can I prevent such warnings in the MySQL error log?
Taxonomy upgrade extras:
skip_name_resolve
Hello oli,
it looks like you have enabled
skip_name_resolve
in yourmy.cnf
.This prevents MySQL to do (DNS) host lookups. If you have created some users with explicit host names MySQL wants to tell you now that you cannot use these users any more with this configuration. Example:
You can find if skip_name_resolve is enabled by the following command:
You can find the conflicting users with the following query:
only the second one does a host name lookup and thus cannot be used any more. The best is to delete this user or change the host name to an IP address:
Now to the second part of your warning: This is possibly a remaining of the
mysql_secure_installation
script which still is or was buggy:The proxies privileges should have been cleaned-up as well but because of the bug it is not. Just delete the record manually: