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 issue

Discussion in 'Data Protection' started by oarecare, Nov 20, 2008.

  1. oarecare

    oarecare Registered

    Nov 20, 2008
    Likes Received:
    Trophy Points:
    i am having trouble creating table grants, and column-specific ones (cannot do it from cpanel). would it be a security issue if i ask my hosting provider to allow my mysql primary user to give grants to the other db users?

    or can i do it by doing a full backup, changing mysql.sql from the tar.gz created, reuploading it to the server and reverting to that?

    (ex: not allowing user to change username, allowing admin to change user's username but not view password etc)

    sample query:
    GRANT SELECT, INSERT (col1, col2, col4, col7, col11, col19) ON `database`.`table` TO 'user'@'host'

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