[HowTo] Extract Database Information From Information_schema Table in Mysql

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.

How to retrieve all database name from  INFORMATION_SCHEMA:

SELECT schema_name FROM INFORMATION_SCHEMA.schemata

After we got database name, now we can get all tables from that database:

SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'the_database_name'

After we got all the tables name from the database, we can retrieve all column name with the data type:

SELECT column_name, column_type FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = 'the_database_name' AND table_name = 'the_table_name'

Okay that’s the basic of how to get some of database information from the Information_Schema, there are still lots of other information you can get from the Information_Schema.

So if your website is vulnerable to SQL Injection, the attacker can easily get your database schema from this technique. So please keep up to date your system and keep backup regularly.

What people search:

Other Interesting Articles:

1. [HowTo] Install Apache, PHP, MySQL, and PHPMyAdmin on Ubuntu
2. [HowTo] Broadcast Radio With Winamp + SHOUTcast to Ubuntu with IceCast2
3. [HowTo] Make Your Windows XP Faster Part 1
4. [HowTo] Radio Streaming Server in Ubuntu Using IceCast2

Article by Ivan Kristianto

Ivan Kristianto is a profesional web developer and blogger. Very interest with free and open source software. Follow my Twitter: @ivankrisdotcom or Facebook profile IvanKristiantoBlog or Email me at ivan@ivankristianto.com

2 comments 1 person listening

Sign in

• Comment help
• Get Livefyre

Post comment as

+ Follow conversation Following - Unfollow

Post to

Sort: Newest | Oldest

Nidhi

thanx a lot....its good to have such website.

share flag

• spam
• offensive
• disagree
• off topic

Like

Ddodiya10

Thanks Sir, it is very usefull.

share flag

• spam
• offensive
• disagree
• off topic

Like