Loading...
четвер, 4 липня 2013 р.

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

Recently I have got such error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'someuser'@'localhost' for table 'sometable'
It's strange, because user 'someuser' have all permissions granted. What is the reason?

Somewhere in code was hard-coded database name, which I was changed later (or, for example, some "default" database used) - so 'sometable' is located in not existing DB now. Access denied, well.

MySQL should show more informative error messages for such situation. Like "sometable does not exists in somedatabase"...

0 коментарі:

 
TOP