mysql中[ERROR] Native table 'performance_schema'案例
环境介绍: 使用yum安装了一个mysql,因版本不符合需求,使用rpm卸载,又用rpm安装了一个版本的Mysql。 报错提示: Mysql安装完毕后,错误日志中报错: [ERROR] Native table 'performance_schema'.'xxxxx' hasthe wrong structure 解决方法: 在操作系统级别,执行mysql_upgrade 报错原因: 当前performance_schema的信息与mysql实际的情况不一致。 参考: If you install MySQL over a previous installation that was configuredwithout the Performance Schema (or with an older version of the PerformanceSchema that may not have all the current tables), runmysql_upgradeafter starting the server to ensure that the performance_schema databaseexists with all current tables. Then restart the server. 本栏目更多精彩内容:http://www.bianceng.cn/database/MySQL/ 如果有兴趣,详见: http://dev.mysql.com/doc/refman/5.5/en/performance-schema-build-configuration.html (编辑:常州站长网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |