I am getting a weird error in my mysql database:

SELECT * FROM mytable 

returns:

ERROR 1932 (42S02): Table 'mydb.mytable' doesn't exist in engine 

I can confirm that the tables do indeed exist on local file system and show tables; does indeed return the tables I am interested in.

show tables;  +-----------------+ | Tables_in_mydb  | +-----------------+ | presets         | | mytable           | +-----------------+ 

And the select:

select * from mytable;  Table 'mydb.mytable' doesn't exist in engine.  

Error makes absolute no sense and I’ve been working with this tables a couple of days ago without any problems. I haven’t moved the tables. What should I do?

Before that error above showed up I was getting an error:

Access denied for user ‘root’@’localhost’ (using password: YES), but I successfully updated the password. I have no idea what triggered this error because I haven’t played with passwords.

However, when I tried to fix this error I have set permissions on /Applications/XAMPP/xamppfiles/var/mysql to read/write to everyone.

I have physical access to .frm and .ibd files of the database. I believe I use InnoDB storage engine.