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!

Weird mySQL permissions

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

  1. rfws03

    rfws03 Member

    May 11, 2003
    Likes Received:
    Trophy Points:

    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

    Sep 20, 2002
    Likes Received:
    Trophy Points:
    Toronto, Ontario Canada
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

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.
    Dismiss Notice