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.

Weird mySQL permissions

Discussion in 'General Discussion' started by rfws03, Sep 7, 2005.

  1. rfws03

    rfws03 Member

    Joined:
    May 11, 2003
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    We recently recieved some information from a user saying that they could see all of the mySQL tables on the server when going into phpMyAdmin in the dropdown menu, however they cannot do anything with the database, and cannot see any of the data in it.

    After looking around it seems that cPanel, for some very odd reason, has granted GLOBAL privledges for most, if not all mySQL users to create temporary tables and lock tables. I can't see the reasoning behind this as you can obviously set these permissions in individual tables, and it is not something that I'd like to explain to our 1000+ hosting customers when they all start asking why they can see everyone elses database.

    Does anyone know what caused this, if it's going to be resolved in a future version, and if there's a nice and quick fix?

    Thanks for any help you can offer in advance, I greatly appreciate it. :)
     
  2. dgbaker

    dgbaker Well-Known Member
    PartnerNOC

    Joined:
    Sep 20, 2002
    Messages:
    2,578
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Toronto, Ontario Canada
    cPanel Access Level:
    DataCenter Provider
Loading...

Share This Page