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 Problem

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

  1. Aritokrat

    Aritokrat Registered

    Joined:
    Dec 8, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    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:
    151
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
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