PJR Sales and Service - Knowledgebase - What is the information

Computer Co-op, CornerNET Internet Gateway, and PJR Solutions is owned by PJR Sales & Service. Quality products and online services since 1991. We can be your
Complete Computer Connection

Hosting @ $5.95

Domains @ $16.98

Home Page

Knowledgebase
You are here: Portal Home > Knowledgebase > cPanel Related Issues > MySQL management issues > What is the information_schema database?

What is the information_schema database?

In MySQL version 5.02 and above there is an additional database called information_schema. This database provides access to the database metadata. This includes the name of a database or a table, the data type of a column, access privileges, etc.

information_schema is the information database where the information about all the other databases is kept. 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.

Add to Favourites
Print this Article

Also Read

How can I import a large database to my account? PhpMyAdmin times out. (Views: 11279)

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database (Views: 10054)

I get syntax error when trying to run a MySQL query. (Views: 1061)

I don't have enough privileges for creating/dropping databases in PhpMyAdmin (Views: 2706)

I have problems accessing my MySQL database remotely (Views: 5298)