MySQL Bugs: #79982: MySQL InnoDB lost tables but files exist

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

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.

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.