-
Property Value Command-Line Format --skip-name-resolve[={OFF|ON}]
System Variable skip_name_resolve
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type Boolean Default Value OFF
Whether to resolve host names when checking client connections. If this variable is
OFF
, mysqld resolves host names when checking client connections. If it isON
, mysqld uses only IP numbers; in this case, allHost
column values in the grant tables must be IP addresses. See Section 8.12.4.2, “DNS Lookup Optimization and the Host Cache”.Depending on the network configuration of your system and the
Host
values for your accounts, clients may need to connect using an explicit--host
option, such as--host=127.0.0.1
or--host=::1
.An attempt to connect to the host
127.0.0.1
normally resolves to thelocalhost
account. However, this fails if the server is run withskip_name_resolve
enabled. If you plan to do that, make sure an account exists that can accept a connection. For example, to be able to connect asroot
using--host=127.0.0.1
or--host=::1
, create these accounts:CREATE USER 'root'@'127.0.0.1' IDENTIFIED BY '
root-password
'; CREATE USER 'root'@'::1' IDENTIFIED BY 'root-password
';