0

I have installed MySql fresh installation version 5.17.9 Mysql services started nicely and giving good throughput But in server logs, I got this type of error: 

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.

Please help me how to fix such issues without restoring database from dump?

miiiii
  • 1,580
  • 1
  • 16
  • 29
SAM AB
  • 177
  • 1
  • 8

1 Answers1

0

As you said its a fresh install, but it doesn't look so.. maybe the cause is not known :P

Solution is to delete those .frm files manually (they are often called orphan files).

For more info..

see this link and this answer too

miiiii
  • 1,580
  • 1
  • 16
  • 29
  • But how will restore that table for MySql . Can you help me in this? @Manoj Shukla – SAM AB Sep 19 '17 at 06:23
  • This is for Innodb engine and i'm not getting actual answer from this! @Manoj – SAM AB Sep 21 '17 at 07:43
  • @SAMAB so which database engine u r using?? – miiiii Sep 21 '17 at 07:48
  • Innodb Engine and Your answer is for MyISAM storage engine @Manoj Shukla – SAM AB Sep 21 '17 at 09:39
  • try following this https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql and let me know if it works.. cuz it looks like that issue is with installation and/or permissions.. and sorry for the late reply, was a bit busy. ;) – miiiii Sep 21 '17 at 10:03
  • if you are unsure abt above process, try creating a new db user as the link says so that we can identify what the issue is. :) – miiiii Sep 21 '17 at 10:05