• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1032
  • 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?
0
Julian Matz
Asked:
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.
0
 
todd_farmerCommented:
Teraplane is exactly right, but I thought I would add a link to the MySQL documentation on the information_schema database:

http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

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';

0
 
Julian MatzAuthor Commented:
Thanks!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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