mysql5.6 innodb_index_stats mysql.slave_master_info表错误的方法

苏康

升级MySQL5.6后系统日志中一直有如下错误存在：
    innodb_index_stats,innodb_tables_stats,slave_master_info,slave_relay_log_info,slave_worker_info这五张表无法读取。详细日志如下：

2015-05-25 17:38:23 1572 [Warning] InnoDB: Cannot open table mysql/innodb_index_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-05-25 17:38:23 1572 [Warning] InnoDB: Cannot open table mysql/innodb_table_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-05-25 17:38:23 1572 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-05-25 17:38:23 1572 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-05-25 17:38:23 1572 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

解决方法：
     登录数据库，进入mysql库，执行如下SQL语句删除5张表

1. drop table if exists innodb_index_stats;
   
2. drop table if exists innodb_table_stats;
   
3. drop table if exists slave_master_info;
   
4. drop table if exists slave_relay_log_info;
   
5. drop table if exists slave_worker_info;

复制代码

    执行完后，停止数据库服务，并进入到数据库data文件所在目录，删除以上5个表所对应的idb文件。
    删除后重新启动数据库，进入到mysql库，导入mysql_system_tables.sql 到mysql数据库。（mysql_system_tables.sql在mysql安装目录的share目录中。）

     导入后这五张表均可正常查询，数据库恢复正常。以上所有操作均在PhpMyAdmin中完成。