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 Problem

Discussion in 'Database Discussions' started by Aritokrat, Dec 17, 2009.

  1. Aritokrat

    Aritokrat Registered

    Joined:
    Dec 8, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Hello,
    I have a question according grant operation. I have database db1 and user1 which has only select privileges on db1. I need to grant INSERT privilege on db1.table1 to user1.
    1) I don not found how to do this in cpanel (it allows to grant on whole database and not for particular table).
    2) in phpMyAdmin there is not privilege to insert or update table TABLE_PRIVILEGES.

    How I can perform GRANT operation?
    Thank you.
     
  2. sven4o

    sven4o Member

    Joined:
    May 21, 2007
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    You can not grant privileges to a user for a single database table through cPanel.

    Ask your server administrator to grant the required privileges.

    Alternatively, add a user with INSERT privileges for the whole database.

    We know cPanel because our web hosting customers love it!
    Check out our special cPanel hosting package!
     
Loading...

Share This Page