MySQL Default information

The first database Information_schema: Provides a way to access database meta data.

Metadata is data about data, such as database name or table name, column data type, or access rights, and so on. Some other terms used to express this information include the data dictionary and the system catalog.

INFORMATION_SCHEMA is an information database that holds information about all the other databases maintained by the MySQL server. In Information_schema, there are several read-only tables. They are actually views, not basic tables, so you will not be able to see any files associated with them.

Each MySQL user has access to these tables, but only to specific rows in the table that contain objects with the appropriate access rights for the user.

Now many people use phpMyAdmin to manage MySQL database, sometimes do not want to let ordinary users through phpMyAdmin see INFORMATION_SCHEMA database, you can set up a

Set such a sentence in config.inc.php (some config.default.php)

$cfg [' Servers '] [$i] [' hide_db '] = ' information_schema ';

SQLyog: When setting the username password, there is a database (s) in which you can specify the db you want to access. But this can only look at one, do not know if the use of ";" Whether the partition will come into effect, has not been tried.

Mysql-front Set Method: If this client does not want to see this "Information_schema", in the Login tab of the set, the username password below, also has a database, specified on it.

Second database MySQL: This is the MySQL core database, similar to the master table in SQL Server, primarily responsible for storing database users, permissions settings, keywords, etc. mysql needs to use control and management information. Can not be deleted, if the MySQL is not very understanding, do not easily modify the database inside the table information.

The third database is test: This is a testing database created at the time of installation and, like its name, is a completely empty database, without any tables that can be deleted.