Native table ‘performance_schema’. ‘file_instances’ has the wrong structure

I am getting the following:

1
<span class="pln">Native </span><span class="kwd">table</span><span class="pln"> </span><span class="str">'performance_schema'</span><span class="pun">.</span><span class="str">'file_instances'</span><span class="pln"> has the wrong structure</span><span class="pln"> Native </span><span class="kwd">table</span><span class="pln"> </span><span class="str">'performance_schema'</span><span class="pun">.</span><span class="str">'rwlock_instances'</span><span class="pln"> has the wrong structure Native </span><span class="kwd">table</span><span class="pln"> </span><span class="str">'performance_schema'</span><span class="pun">.</span><span class="str">'mutex_instances'</span><span class="pln"> has the wrong structure </span><span class="pun">...</span>

The problem appears if you have inconsistant data or you have upgraded MySQL

Solution:

Backup your databases first,

reinstall mysql

restore you databases.

OR

run mysql_upgrade

It the root is password protected

mysql-upgrad –password

I hope it will resolve the problem.