SELECT command denied to user

[dsouza]

Hello guys,

I've a website that uses mysql_query function with 5.6 PHP version and I'm getting this following error:

SELECT command denied to user 'user'@'localhost' for table 'access'

If I access remotely using a MySQL client like the Beekeeper Studio I can run the same query without problem, but if I run the query through the mysql_query in the server localhost generates that error.

Can anyone give an idea of what it could be?

 

[Richard G]

I don't. But did you check Google first? If I give that eror line into Google, I got a lot of these with solutions too.
Like this one for example, might be helpfull, but there are others to be found too:

SELECT command denied to user <userID>@<your ip address> for table <table name>

i faced this error while calling the query to the database to the clearDB . it returns the error i specified in the title... SELECT command denied to user @ for table ...... i uploaded my clearDB on

stackoverflow.com