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!
  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:
    833
    Likes Received:
    13
    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,556
    Likes Received:
    41
    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:
    833
    Likes Received:
    13
    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,556
    Likes Received:
    41
    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:
    833
    Likes Received:
    13
    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,556
    Likes Received:
    41
    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. sahostking

    Information schema and diskspace used query

    sahostking, Jan 8, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    217
    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:
    420
    cPanelMichael
    Nov 9, 2017
  3. bluecup

    SOLVED OPcache information not showing in phpinfo

    bluecup, Apr 27, 2018, in forum: EasyApache
    Replies:
    5
    Views:
    132
    cPanelMichael
    May 15, 2018
  4. 01i

    Mail Service Information Incorrect

    01i, Apr 19, 2018, in forum: E-mail Discussion
    Replies:
    3
    Views:
    99
    01i
    May 16, 2018
  5. Bidi

    Incremental Backup creates Full instead of information that has changed

    Bidi, Feb 21, 2018, in forum: Data Protection
    Replies:
    7
    Views:
    273
    cPanelMichael
    Feb 26, 2018

Share This Page