The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    788
    Likes Received:
    6
    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,493
    Likes Received:
    31
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    #2 cPanelKenneth, Jan 7, 2008
  3. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    788
    Likes Received:
    6
    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,493
    Likes Received:
    31
    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
     
    #4 cPanelKenneth, Jan 8, 2008
  5. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    788
    Likes Received:
    6
    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,493
    Likes Received:
    31
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    It depends upon your customer.

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

    Package Information

    Rehan_1990, Aug 17, 2017 at 3:05 AM, in forum: General Discussion
    Replies:
    1
    Views:
    25
    cPanelMichael
    Aug 17, 2017 at 10:34 AM
  2. Dante78

    Server Error: STATUS: Internal error occurred. Refer to server log for more information.

    Dante78, Jul 24, 2017, in forum: E-mail Discussions
    Replies:
    2
    Views:
    114
    cPanelMichael
    Jul 24, 2017
  3. Chris H

    Preventing users viewing system information

    Chris H, May 5, 2017, in forum: Security
    Replies:
    2
    Views:
    154
    Chris H
    May 5, 2017
  4. webstyler

    AutoSSL/SSL Resource information

    webstyler, Apr 29, 2017, in forum: Security
    Replies:
    1
    Views:
    174
    cPanelMichael
    May 2, 2017
  5. DigitalEssence

    SOLVED zone information confusion since enabling DNS cluster and transferring a site

    DigitalEssence, Apr 27, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    2
    Views:
    232
    cPanelMichael
    Apr 28, 2017

Share This Page