What is the information_schema database?
Author: admin admin Reference Number: AA-00338 Views: 6403 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.

Quick Jump Menu