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!

MySQL Grant command and table level permissions

Discussion in 'Database Discussion' started by toby200, Oct 16, 2012.

  1. toby200

    toby200 Registered

    Joined:
    Oct 16, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hi,

    I'm a website owner using CPanel with mySQL. I need to be able to grant individual users table-level access permissions for a specific database, such that different users can update different tables (but all users have read access).

    From talking to the webhost and various posts on the internet it appears there's no way to do this via CPanel, and even after the webhost manually granted me access, it still does not appear to work:

    admins ran: GRANT ALL, GRANT_OPTION ON cumnorpa_subs.* TO cumnorpa
    I then run: GRANT UPDATE ON cumnorpa_subs.subscription to 'cumnorpa_dist'
    And got the response: GRANT command denied to user 'cumnorpa'@'localhost' for table 'subscription'

    Is there any way at all to manage table-level permissions for a database that is managed under CPanel (even if it means the webhost running commands manually for me)

    Many thanks
    Toby
     
Loading...

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