content_image/752107.jpg content_image/752111.jpg content_image/752115.jpg
CREATE USER ’root’@’127.0.0.1’ IDENTIFIED BY ’ root-password ’; CREATE USER ’root’@’::1’ IDENTIFIED BY ’ root-password ’; 

• skip_networking 

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

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 

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

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. 

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

## Caution 

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. 

