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

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’

腾讯云限时秒杀【点击购买】

搬瓦工,CN2高速线路,1GB带宽,电信联通优化KVM,延迟低,速度快,建站稳定,搬瓦工BandwagonHost VPS优惠码BWH26FXH3HIQ,支持<支付宝> 【点击购买】!

Vultr$3.5日本节点,512M内存/500G流量/1G带宽,电信联通优化,延迟低,速度快【点击购买】!

阿里云香港、新加坡VPS/1核/1G/25G SSD/1T流量/30M带宽/年付¥288【点击购买】

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

`微信`扫码 加好友

链接到文章: https://gkxyz.com/xiufumysqlerror-native-table-performance_schema.html

推荐站点

  • Vultr

    Vultr Global Cloud Hosting – Brilliantly Fast SSD […]

  • 优酷 – 你的热爱 正在热播

    视频服务平台,提供视频播放,视频发布,视频搜索,视频分享

  • 观察者网

    观察者网,致力于荟萃中外思想者精华,鼓励青年学人探索,建中西文化交流平台,为崛起中的精英提供决策参考。

  • 站长工具 – 站长之家

    站长工具是站长的必备工具。经常上站长工具可以了解SEO数据变化。还可以检测网站死链接、蜘蛛访问、HTML格式检 […]

  • 阿里云-为了无法计算的价值

    阿里云——阿里巴巴集团旗下公司,是全球领先的云计算及人工智能科技公司之一。提供免费试用、云服务器、云数据库、云 […]

  • 七牛云 | 一站式场景化智能视频云

    2011 年成立以来,七牛云致力于成为全球领先的一站式场景化智能视频云服务商,围绕数字化浪潮下的在线音视频需求 […]

评论已关闭