修复mysql:[ERROR] Native table ‘performance_schema’

来源: 老季博客
日期: 2017-7-6
作者: 腾讯云/服务器VPS推荐评测/Vultr
阅读数: 48

mysql数据库出现如下错误,主要是因为升级了mysql软件包,而一些数据库的表结构发生变化而无法正常运行。

140213 16:55:47 [ERROR] Native table ‘performance_schema’.’events_waits_current’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’events_waits_history’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’events_waits_history_long’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’setup_consumers’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’setup_instruments’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’setup_timers’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’performance_timers’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’threads’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’events_waits_summary_by_thread_by_event_name’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’events_waits_summary_by_instance’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’events_waits_summary_global_by_event_name’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’file_summary_by_event_name’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’file_summary_by_instance’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’mutex_instances’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’rwlock_instances’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’cond_instances’ has the wrong structure
140213 16:55:47 [ERROR] Native table ‘performance_schema’.’file_instances’ has the wrong structure

修复方法很简单只需在root权限下运行如下命令即可:

/usr/local/mysql/bin/mysql_upgrade -u root -p

输入命令后会要求验证mysql密码,填入密码后确认如下图所示即表示修复完毕:

修复mysql:[ERROR] Native table ‘performance_schema’

链接到文章: https://jiloc.com/43376.html

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注