Server System Variables CREATE USER ’root’@’127.0.0.1’ IDENTIFIED BY ’ root-password ’; CREATE USER ’root’@’::1’ IDENTIFIED BY ’ root-password ’; • skip_networking Command-Line Format --skip-networking[={OFF|ON}] System Variable skip_networking Scope Global Dynamic No SET_VAR  Hint Applies No Type Boolean Default Value OFF This variable controls whether the server permits TCP/IP connections. By default, it is disabled (permit TCP connections). If enabled, the server permits only local (non-TCP/IP) connections and all interaction with  mysqld  must be made using named pipes or shared memory (on Windows) or Unix socket files (on Unix). This option is highly recommended for systems where only local clients are permitted. See Section 5.1.12.3, “DNS Lookups and the Host Cache” . Because starting the server with  --skip-grant-tables  disables authentication checks, the server also disables remote connections in that case by enabling  skip_networking . • skip_show_database Command-Line Format --skip-show-database System Variable skip_show_database Scope Global Dynamic No SET_VAR  Hint Applies No Type Boolean Default Value OFF This prevents people from using the  SHOW DATABASES  statement if they do not have the  SHOW DATABASES  privilege. This can improve security if you have concerns about users being able to see databases belonging to other users. Its effect depends on the  SHOW DATABASES  privilege: If the variable value is  ON , the  SHOW DATABASES  statement is permitted only to users who have the  SHOW DATABASES  privilege, and the statement displays all database names. If the value is  OFF ,  SHOW DATABASES  is permitted to all users, but displays the names of only those databases for which the user has the  SHOW DATABASES  or other privilege. Because any static global privilege is considered a privilege for all databases, any static global privilege enables a user to see all database names with  SHOW DATABASES  or by examining the  SCHEMATA  table of  INFORMATION_SCHEMA , except databases that have been restricted at the database level by partial revokes. Caution 882