解决MySQL5.6版本”innodb_table_stats” not found

MySQL启动时, 在error log中报错如下

2015-01-30 17:00:45 7f4d6a59c700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-01-30 17:00:45 7f4d6a59c700 InnoDB: Error: Fetch of persistent statistics requested for table "xxx"."wp3_options" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
......

以root登陆mysql

use mysql;

drop table `innodb_index_stats`;

drop table `innodb_table_stats`;

drop table `slave_master_info`;

drop table `slave_relay_log_info`;

drop table `slave_worker_info`;

执行时若报table不存在的错误,可以不用管.

然后进入mysql的datadir, 执行

rm -f innodb_* slave_*

在到mysql中, 执行

source /yourpath/five-tables.sql

附件: five-tables

重启MySQL, 错误不再有了.