I have been using MY SQL workbench for awhile to run statments and now am getting the following error message:

Error Code: 1142 Select command denied to user 'R1@IPaddress for table HD_Ticket'

Where I put IPaddress this shows the actual IP address in the error message.

Has anyone else seen this error message and if so how did you fix it?

 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

What is you select statement?

Answered 01/08/2013 by: X019
White Belt

Please log in to comment
0

Yes when there is a problem with your sql statement you will sometimes get this error.

Post your code and we can take alook and be of more help.

It usually is related ot a JOIN or UNION that has incorrect syntax or even a misspelled table name can cause it. Instead of telling you that table doesnt exists It will say basically you dont have permissions.

A usual suspect is the difference betwwen foo_BAR and foo.BAR

 

Select Denied for foo.Bar

Answered 01/08/2013 by: jdornan
Red Belt

Please log in to comment
0

Thanks it's a long SQL statement; I found the problem. 

Answered 01/09/2013 by: scarpent
Second Degree Black Belt

Please log in to comment
0

I just recently started getting this after upgrading to 5.4.  I get this even with a simple query like

 SELECT ID
 FROM ASSET;

However, if I add the ORG1 schema, the query works:

SELECT ID
FROM ORG1.ASSET;

Any hints??

Answered 01/14/2013 by: grayematter
Fourth Degree Black Belt

Please log in to comment
0

Well if you are inside mysql workbench just double click org 1 to make it the default db and you won't need to use this syntax. It assumes the 

use org1

go

syntax or prefixing the table with db name as you were doing

Answered 01/14/2013 by: jdornan
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share