I have a two databases, when I prompt SHOW DATABASES I can see a list of the databases, including mysql, performance_schema and informations_schema. I can prompt 'SELECT DATABASE_NAME' on both of them, I can prompt 'SHOW TABLES' on both of them, but when I try to query I get the error mentioned in the title of this question. I use MySQL 5.7.7, and the InnoDB is set to FILE_PER_TABLE. All files are in the correct folder, including the ibdata1 and both of the log files.

Does anyone has a solution?

closed as unclear what you're asking by Colin 't Hart, ypercubeᵀᴹ, dezso, Shawn Melton, Max Vernon Jul 28 '15 at 4:12

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


I think you might be able to find the answer in the following post: https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should

Seems to have the same issue as you.

Not the answer you're looking for? Browse other questions tagged or ask your own question.