Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

DB: "information schema" visible to users

Discussion in 'General Discussion' started by 4u123, Jan 7, 2008.

  1. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    842
    Likes Received:
    14
    Trophy Points:
    168
    Hi,

    Customer just told me he can see a database called "information schema" containing 17 tables in his phpmyadmin. Could anyone advise on how to fix this ?
     
    #1 4u123, Jan 7, 2008
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,565
    Likes Received:
    43
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelKenneth, Jan 7, 2008
  3. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    842
    Likes Received:
    14
    Trophy Points:
    168
    Hi Kenneth,

    If its a system database of some sort then why can all my customers see it in phpmyadmin ?

    Surely the "fix" would be for cpanel to ensure that such system databases cant be seen by regular users ?
     
    #3 4u123, Jan 7, 2008
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,565
    Likes Received:
    43
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    Because:

    1. That database contains meta data necessary for MySQL 5 to function
    2. A MySQL user can only see in that database what he actually has access to
    3. It's not actually a database, but a view
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelKenneth, Jan 8, 2008
  5. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    842
    Likes Received:
    14
    Trophy Points:
    168
    ok,

    Can you tell me what a customer would use it for ?
     
    #5 4u123, Jan 8, 2008
  6. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,565
    Likes Received:
    43
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    It depends upon your customer.

    I use it to check the stored procedures I create.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelKenneth, Jan 9, 2008
(You must log in or sign up to post here.)
Loading...
Similar Threads - information schema visible
  1. sahostking

    Information schema and diskspace used query

    sahostking, Jan 8, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    376
    sahostking
    Jan 21, 2018
  2. ottdev

    v68 new option to disable information schema searches

    ottdev, Nov 7, 2017, in forum: Database Discussion
    Replies:
    3
    Views:
    661
    cPanelMichael
    Nov 9, 2017
  3. Nirjonadda

    In Progress [CPANEL-23606] cPanel Security Advisor missing kernel information when kernelcare is installed

    Nirjonadda, Oct 19, 2018, in forum: General Discussion
    Replies:
    10
    Views:
    150
    cPanelLauren
    Oct 24, 2018
  4. Zurrie

    Mail Client Manual Settings Information SSL and non-SSL

    Zurrie, Sep 13, 2018, in forum: E-mail Discussion
    Replies:
    3
    Views:
    139
    cPanelMichael
    Sep 14, 2018
  5. Edwin Huijsing

    information needed for .cpanel.yml

    Edwin Huijsing, Aug 20, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    540
    Edwin Huijsing
    Aug 22, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice