Bug #79982 MySQL InnoDB lost tables but files exist
Submitted: 14 Jan 2016 10:57 Modified: 14 Jan 2016 12:49
Reporter: Deepak Kakran Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version: OS:Windows
Assigned to: CPU Architecture:Any

[14 Jan 2016 10:57] Deepak Kakran
Description:
I changed the password of root, and after that not able to access some tables from few databases. Getting the list of the tables at left in phpmyadmin, but not on right side. Even not able to do select, alter, delete, drop etc commands on the tables. It shows an error 1146. .frm and .ibd files are still available.

How to repeat:
I changed the password of root, and after that not able to access some tables from few databases. Getting the list of the tables at left in phpmyadmin, but not on right side. Even not able to do select, alter, delete, drop etc commands on the tables. It shows an error 1146. .frm and .ibd files are still available.
[14 Jan 2016 12:49] MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.