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.

  • 13 användare blev hjälpta av detta svar
Hjälpte svaret dig?

Relaterade artiklar

What type of databases do you support? PGSQL and MySQL?

All our servers support MySQL and PostgreSQL databases. Also with any of our hosting packages...

How to repair a MySQL database?

In this article we will show you two ways to repair a MySQL database.  1) Through...

How to optimize a MySQL database using phpMyAdmin?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

How to change the database engine of a MySQL database table?

In this article we will show you how to change the database engine of a MySQL table. Let's...

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database

In order to solve this issue follow these steps: Open the MySQL dump with a text editor on...