MySQL table information_schema

Posted on 2007-08-11
Last Modified: 2012-06-21
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?
Question by:Julian Matz
    LVL 19

    Accepted Solution

    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.
    LVL 30

    Assisted Solution

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

    LVL 21

    Author Comment

    by:Julian Matz

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Suggested Solutions

    Title # Comments Views Activity
    MySQL Row_Number group by ID 5 38
    WordPress AWS: site goes down 2 67
    Get AVG of SUM in MySQL with other SUMS 5 34
    MySQL Error 3 0
    I have been using r1soft Continuous Data Protection ( for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now