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.

MySQL Grant command and table level permissions

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

  1. toby200

    toby200 Registered

    Oct 16, 2012
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Website Owner

    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

Share This Page