ERROR 1142 (42000): SELECT command denied to user ''@'localhost' for table 'user'

Asked Jun 26 '18 at 08:22

Active Jun 26 '18 at 08:30

Viewed 1,047 times

I am getting mysql 1142 error on the following query

mysql> SELECT host, user ,password, Grant_priv, Super_priv FROM mysql.user;
ERROR 1142 (42000): SELECT command denied to user ''@'localhost' for table 'user'

Can someone help me with the ERROR 1142 (42000)?

screen

edited Jun 26 '18 at 08:30

Sivabalan

asked Jun 26 '18 at 08:22

Audrey Frt

2

Possible duplicate of [Error: select command denied to user ''@'' for table ''](https://stackoverflow.com/questions/4767055/error-select-command-denied-to-user-useridip-address-for-table-table) – Sivabalan Jun 26 '18 at 08:30
Sorry it still doesn't work – Audrey Frt Jun 26 '18 at 08:39

ERROR 1142 (42000): SELECT command denied to user ''@'localhost' for table 'user'

0 Answers0