The configuration community:
Search the Site:

skip_show_database

Information

This prevents people from using the SHOW DATABASES statement if they do not have the SHOW DATABASES privilege. This can improve security if you are concerned about people being able to see what databases other users have. See also safe_show_database. This variable was added in MySQL 3.23.4. As of MySQL 4.0.2 its effect also depends on the SHOW DATABASES privilege: If the variable value is ON the SHOW DATABASES statement is allowed only to users who have the SHOW DATABASES privilege and the statement displays all database names. If the value is OFF SHOW DATABASES is allowed to all users but displays each database name only if the user has the SHOW DATABASES privilege or some privilege for the database. Note that any global privilege is a privilege for the database.

Syntax

Example

728x90