MySql服务器安装后记录错误

Question

我已经安装了MySql全新安装版本5.17.9 Mysql 服务启动良好并提供良好的吞吐量但在服务器日志中，我收到了此类错误:

InnoDB: Cannot open table mysql/engine_cost from the internal data dictionary of InnoDB though the .frm file for the table exists.   
Cannot open table mysql/gtid_executed from the internal data dictionary of          InnoDB though the .frm file for the table exists.   
 Cannot open table mysql/help_category from the internal data dictionary of InnoDB though the .frm file for the table exists.   
Cannot open table mysql/help_keyword from the internal data dictionary of InnoDB though the .frm file for the table exists.  
 Cannot open table mysql/help_relation from the internal data dictionary of InnoDB though the .frm file for the table exists.  
 Cannot open table mysql/help_topic from the internal data dictionary of InnoDB though the .frm file for the table exists.  
 Cannot open table mysql/innodb_index_stats from the internal data dictionary of InnoDB though the .frm file for the table exists.   
 Cannot open table mysql/innodb_table_stats from the internal data dictionary of InnoDB though the .frm file for the table exists.  
Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists.    
 Cannot open table mysql/server_cost from the internal data dictionary of InnoDB though the .frm file for the table exists.   
 Cannot open table mysql/servers from the internal data dictionary of InnoDB though the .frm file for the table exists.  
 Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists.  
Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists.   
 Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists.   
Cannot open table mysql/time_zone from the internal data dictionary of InnoDB though the .frm file for the table exists.  
 Cannot open table mysql/time_zone_leap_second from the internal data dictionary of InnoDB though the .frm file for the table exists.   
 Cannot open table mysql/time_zone_name from the internal data dictionary of InnoDB though the .frm file for the table exists.  
 Cannot open table mysql/time_zone_transition from the internal data dictionary of InnoDB though the .frm file for the table exists.  
 Cannot open table mysql/time_zone_transition_type from the internal data dictionary of InnoDB though the .frm file for the table exists.

请帮助我如何在不从转储恢复数据库的情况下解决此类问题？

Answer 1

正如您所说，它是全新安装，但看起来并非如此..也许原因未知:P

解决方案是手动删除这些 .frm 文件(它们通常称为孤立文件)。

了解更多信息..

参见this link和 this answer too