Permissions Issue

[James Tow]

I have a table that is of type INNODB.

The grant for this table is:

GRANT SELECT ON TABLE mydatabase.mytable_name TO 'userindb'@'%';

Then, they can't access it. This is the error that is generated in the error log:

SELECT command denied to user 'unserindb'@'123.45.67.89' for table 'mytable_name'

I am not a MySQL DBA so I don't know the options available that may be causing this problem. Any insight to this issue?

Thank you in advance for your time and consideration!

James