881 Server System Variables • skip_external_locking • skip_name_resolve Whether to resolve host names when checking client connections. If this variable is  OFF ,  mysqld resolves host names when checking client connections. If it is  ON ,  mysqld  uses only IP numbers; in this case, all  Host  column values in the grant tables must be IP addresses. See Section 5.1.12.3, “DNS Lookups 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 the  localhost  account. However, this fails if the server is run with  skip_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 as  root  using  -- host=127.0.0.1  or  --host=::1 , create these accounts: External locking affects only  MyISAM  table access. For more information, including conditions under which it can and cannot be used, see Section 8.11.5, “External Locking” . This variable is set by the  --external-locking  or  --skip-external-locking  option. External locking is disabled by default. This is  OFF  if  mysqld  uses external locking (system locking),  ON  if external locking is disabled. This affects only  MyISAM  table access. As of MySQL 8.0.26, setting the session value of this system variable is a restricted operation. The session user must have privileges sufficient to set restricted session variables. See Section 5.1.9.1, “System Variable Privileges” . This variable is deprecated and subject to removal in a future MySQL release. Output for the  COLUMN_TYPE  column of the  INFORMATION_SCHEMA.COLUMNS  table is affected similarly. Command-Line Format --skip-external-locking[={OFF|ON}] System Variable skip_external_locking Scope Global Dynamic No SET_VAR  Hint Applies No Type Boolean Default Value ON Command-Line Format --skip-name-resolve[={OFF|ON}] System Variable skip_name_resolve Scope Global Dynamic No SET_VAR  Hint Applies No Type Boolean Default Value OFF