Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.11.3
-
None
-
Windows
Description
The documentation for skip-name-resolve says:
> All host values in the GRANT tables must be IP addresses (or localhost).
(https://mariadb.com/kb/en/server-system-variables/#skip_name_resolve)
However, "localhost" doesn't work with said variable set to 1 (I've only tested it on Windows).
I have a user repl_status@localhost configured. This works fine with skip-name-resolve=0. With skip-name-resolve=1, I get one of the following warnings in the log file (depending what IP version is used):
>[Warning] Access denied for user 'repl_status'@'::1' (using password: YES)
>[Warning] Access denied for user 'repl_status'@'127.0.0.1' (using password: YES)
Also note that the log file has warnings during startup for ignored entries like this:
> [Warning] 'user' entry 'root@c-2tcmqb3' ignored in --skip-name-resolve mode.
(Where c-2tcmqb3 is the host name.)
There is no such warning for @localhost.
Option 1: localhost isn't supposed to work: Then the documentation is wrong and the warning is missing.
Option 2: localhost is supposed to work: Well, it doesn't.
Side note: HeidiSQL has a dialog window for user accounts, in which it displays lines with host names in grey color when skip-name-resolve=1. It doesn't do that for localhost.