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 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