SELECT denied FOR table with column priviligies

Asked Jan 01 '16 at 22:20

Active Jan 01 '16 at 23:10

Viewed 72 times

I'm trying to add a user with permissions to view only certain columns in a table.

When trying to access that table from phpMyadmin i get #1142 - SELECT command denied to user 'fhg-stats'@'localhost' for table 'rk_upd' error

But if I query the table using SQL like SELECT col1, col2 FROM table i do see the correct result. So obviously I do have privileges to see the wanted columns.

But why can't i just view the table direct in phpMyadmin?

EDIT flush privileges doesn't make any difference. Also the problem persists even from other clients than phpmyadmin

edited Jan 01 '16 at 23:10

asked Jan 01 '16 at 22:20

Philip G

4,098
2
22
41

Any change if you run `flush privileges` – Mihai Jan 01 '16 at 22:24
Sadly no. still #1142 – Philip G Jan 01 '16 at 22:26
1

phpmyadmin can be buggy upgrade to the latest version – Mihai Jan 01 '16 at 22:26
i'm not able to upgrade at this moment, no other work around? – Philip G Jan 01 '16 at 22:55
1

Or try a different client to rule out bugs like heidisql – Mihai Jan 01 '16 at 22:56
I tried using CODA, same error. seems related to that the `SELECT * FROM table` is not allowed. – Philip G Jan 01 '16 at 23:03
http://stackoverflow.com/questions/18424797/1142-select-command-denied-to-user-localhost-for-table-pma-table-uipref – Mihai Jan 01 '16 at 23:06

SELECT denied FOR table with column priviligies

0 Answers0