content_image/731989.jpg content_image/731990.jpg
Output for the COLUMN_TYPE  column of the INFORMATION_SCHEMA.COLUMNS  table is affected similarly. 

This variable is deprecated and subject to removal in a future MySQL release. 

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” . 

• skip_external_locking 

<img src='content_image/731989.jpg'>

This is OFF  if mysqld  uses external locking (system locking), ON  if external locking is disabled. This affects only MyISAM  table access. 

This variable is set by the --external-locking  or --skip-external-locking  option. External locking is disabled by default. 

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” . 

• skip_name_resolve 

<img src='content_image/731990.jpg'>

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: 

