Like many people, I run mysql with
skip-name-resolve (docs), and only ever use IP addresses to connect to avoid DNS issues and overhead. When installing,
mysql_install_db accepts a
--skip-name-resolve switch (docs), so with those two set you would expect it to not create name-based users, but this is not the case. With both of those set, there are two name-based users created and so I get this in my logs on startup:
140309 18:47:16 [Warning] 'user' entry 'firstname.lastname@example.org' ignored in --skip-name-resolve mode. 140309 18:47:16 [Warning] 'user' entry '@hostname.localdomain' ignored in --skip-name-resolve mode.
How do I stop it from creating these users in the first place?
I'm running MySQL 5.1.70 on OpenBSD 5.4 (current release package).