请问 Table 'mysql.innodb_table_stats' doesn't exist 如何解决

李惟
  • 2.1k

执行代码:

/usr/bin/mysqlinstalldb --user=mysql

查看mysql_error.log发现有错误:

2013-10-27 10:34:32 9305 [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.  
ERROR: 1146  Table 'mysql.innodb_table_stats' doesn't exist  
2013-10-27 10:34:32 9305 [ERROR] Aborting

2013-10-27 10:34:32 9305 [Note] Binlog end

网上搜好像是说“没编译innodb吧”,但是没有提供具体解决方法,请问如何解决这个问题呢?

回复
阅读 12.3k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
宣传栏