Allow ordinary users to log on to phpmyadmin without displaying information_schema

Source: Internet
Author: User
Allow normal users to log on to phpmyadmin without displaying information_schemahttp: // metadata, and allow normal users to log on to phpmyadmin without displaying information_schema.
Http://www.cnblogs.com/faily201/articles/2283245.html wrote in general, we installed mysql, with phpmyadmin login management, will find in addition to their own installed database, there is a information_schema database. Even if the permission is set, the table is still displayed. The table displays information about all users. Although the password is not displayed, you must disable it for security purposes.
First, what is information_schema?
INFORMATION_SCHEMA is an information database that stores information about all other databases maintained by the MySQL server. There are several read-only tables in INFORMATION_SCHEMA. They are actually views rather than basic tables, so you won't be able to see any files related to them.

Each MySQL User has the right to access these tables, but is limited to specific rows in the table. such rows contain objects that the user has the right to access.
The following details:

The information_schema database comes with MySQL, which provides a way to access database metadata. What is metadata? Metadata is data about data, such as database name or table name, column data type, or access permission. In some cases, other terms used to express this information include "data dictionary" and "system Directory ".
In MySQL, information_schema is regarded as a database, specifically an information database. Information about all other databases maintained by the MySQL server is saved. Such as the database name, database table, and data type and access permissions in the table column. There are several read-only tables in INFORMATION_SCHEMA. They are actually views rather than basic tables, so you won't be able to see any files related to them.

Information_schema database table description:

SCHEMATA table: provides information about all databases in the current mysql instance. Is the result of show databases.

TABLES Table: provides information about TABLES in the database (including views ). Describes in detail the schema, table type, table engine, and creation time of a table. Is the result of show tables from schemaname.

COLUMNS table: Provides column information in the table. Describes all the columns of a table and the information of each column in detail. Is the result of show columns from schemaname. tablename.

STATISTICS table: provides information about table indexes. Is the result of show index from schemaname. tablename.

USER_PRIVILEGES (user permission) table: provides information about full-process permissions. This information is from the mysql. user authorization table. Non-standard table.

SCHEMA_PRIVILEGES (scheme permission) table: provides information about the scheme (database) permission. This information is from the mysql. db authorization table. Non-standard table.

TABLE_PRIVILEGES table: lists table permissions. This information is from the mysql. tables_priv authorization table. Non-standard table.

COLUMN_PRIVILEGES (column permission) table: provides information about the column permission. This information is derived from the mysql. columns_priv authorization table. Non-standard table.

CHARACTER_SETS table: provides information about available character sets of mysql instances. This table is obtained from the show character set result SET.

COLLATIONS table: provides control information about each character set.

COLLATION_CHARACTER_SET_APPLICABILITY table: specifies the character set that can be used for verification. These columns are equivalent to the first two display fields of show collation.

TABLE_CONSTRAINTS table: describes tables with constraints. And the constraint type of the table.

KEY_COLUMN_USAGE table: describes the restricted key columns.

ROUTINES table: provides information about stored subroutines (stored programs and functions. In this case, the ROUTINES table does not contain Udfs ). The column named "mysql. proc name" specifies the mysql. proc table column corresponding to the INFORMATION_SCHEMA.ROUTINES table.

VIEWS table: displays information about VIEWS in the database. You must have the show views permission. Otherwise, you cannot view information.

TRIGGERS table: provides information about the trigger program. You must have the super permission to view the table.

So how can we make it invisible?
The answer is as follows:
If you do not want to display it in phpMyAdmin, you only need to set this in config. inc. php (some are config. default. php ).

$ Cfg ['servers'] [$ I] ['hide _ db'] = 'information _ scheme ';

?

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.