|
What is the information_schema database?
Author: admin admin Reference Number: AA-00338 Views: 9421 Created: 2013-04-11 13:05 Last Updated: 2013-04-11 13:05 |
0 Rating/ Voters
|
|
In MySQL version 5.02++ there is an additional database called information_schema.
This database is available inside the cPanel -> phpMyAdmin tool and
provides access to the database metadata for the corresponding user.
information_schema is the database where the
information about all the other databases is kept, for example names of a
database or a table, the data type of columns, access privileges, etc.
It is a built-in virtual database with the sole purpose of providing
information about the database system itself. The MySQL server
automatically populates the tables in the information_schema.
The important thing to remember about the information_schema database
is that you can query it, but you cannot change its structure or modify
its data.
|
|
|
|
|
|
|
|