phpMyAdmin GRANT SELECT on one table in DB?

gogy82

• April 23, 2015 08:29

Hello guys I wanted to grant select privileges to user on one table only tried this way with root user trough WHM->cPanel->phpMyAdmin
GRANT SELECT ON dbname.tblname to 'dbuser'
Error
#1142 - GRANT command denied to user 'cpses_im2lk8XfRe'@'localhost' for table 'tblname'
How to GRANT SELECT on one table only to user? I don't want this user to see all tables. Thank you Kind regards Goran

• 

  cPanelMichael

  • April 24, 2015 14:11

  Hello, I could not reproduce this issue on a test machine. Are you accessing Web Host Manager directly, and as "root"? Also, do you experience the same issue through the command line via SSH? Thank you.

  0

Please sign in to leave a comment.