ERROR 1142 42000 SELECT command denied to user localhost for table user

Question

Hi,

When I set the privilege with the help of this command:

mysql> select Host,User from mysql.user;

I came up with this error: 

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

Can anyone suggest how can I come up with this error?

Answer 1

Hey,

This is a mysql command line error message, this Means you are logged into mysql with a default null user with just about zero privileges.

You can follow some steps to remove the error:

Run the mysql command which will bring you to mysql promt:

mysql -u root

Run the command

select user();

Then run another command:

select user from mysql.user;

I hope you won't get the error anymore.

Learn more about Big Data Architect and its concepts from the Data architect course.

Comments

i can t use this command

select user from mysql.user;

And showed this error

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

---

Hi

You need to give SELECT permissions to the MySQL user who is connecting to MySQL. I think that's where you went wrong.