• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1036
  • Last Modified:

MySQL table information_schema

Hi! I recently upgraded MySQL to version 5 and also updated to the latest Debian version of phpMyAdmin (2.9). I noticed that each MySQL user has an extra table - information_schema (16).

I presume this is normal?? I mean, I also noticed that users can only view records but not edit privileges or anything... It's obviously there to view user's settings/privileges... That's ok, right?
Julian Matz
Julian Matz
2 Solutions
Kim RyanIT ConsultantCommented:
The information_schema  is there as meta data, or a table about tables. (Orcale has had this for ages). It is there when you want to get a query that can return info about tables and columns within tables etc.

All user setting are still maintained the old way, in the uers and priviliges tables.
Teraplane is exactly right, but I thought I would add a link to the MySQL documentation on the information_schema database:


It's very useful for finding the definitions of tables, columns, views and other database objects without parsing SHOW CREATE TABLE or similar commands.  For example, if you want to know all the tables that have a column with the name "id":

SELECT table_name FROM information_schema.columns WHERE column_name = 'id';

Julian MatzJoint ChairpersonAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now