I used below command to grant select PRIVILEGES on specific columns of one MYSQL DB table.

GRANT SELECT (p_id) ON DB_NAME.TABLE_NAME TO ‘dbuser’@’localhost’

It is showing given PRIVILEGES with SHOW GRANTS command but when i login to PHPMYADMIN with this user and try to select DB Table, it gives error

#1142 – SELECT command denied to user ‘dbuser’@’localhost’ for table ‘my_users’

Please help me out,how can i give select feature on specific columns of DB table.