Forum Moderators: open

Message Too Old, No Replies

information schema Database

New hosting subcription

         

Gian04

4:21 am on May 31, 2008 (gmt 0)

10+ Year Member



I just subscribe to a new host for a shared hosting. I have not created any database yet but on my phpMyAdmin, it already have 1 database named information_schema and it has 17 tables (with records).

What is it?

wingnut

10:12 am on May 31, 2008 (gmt 0)

10+ Year Member



Go Google!

Quote:

INFORMATION_SCHEMA provides access to database metadata.
Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes are used for this information are data dictionary and system catalog.
INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains. Inside INFORMATION_SCHEMA there are several read-only tables. They are actually views, not base tables, so there are no files associated with them.
In effect, we have a database named INFORMATION_SCHEMA, although the server does not create a database directory with that name. It is possible to select INFORMATION_SCHEMA as the default database with a USE statement, but it is possible only to read the contents of tables. You cannot insert into them, update them, or delete from them.

rocknbil

3:51 pm on May 31, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Relevant MySQL Docs [dev.mysql.com]

noyearzero

6:55 am on Jun 29, 2008 (gmt 0)

10+ Year Member



if you have access to the config files you can add a line that hides the table if you want.