performance_schema 修复

2018-10-15 19:38:17 4341 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect information in file: ‘./performance_schema/accounts.frm‘
2018-10-15 19:38:17 4341 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect information in file: ‘./performance_schema/cond_instances.frm‘

修复方法为： /usr/local/mysql/bin/mysql_upgrade -h127.0.0.1 -uroot -p‘111111‘

修复后记得重启下数据库
/etc/init.d/mysqld restart

然后再去查看日志里是否出现performance_schema 报错

performance_schema 修复

原文：http://blog.51cto.com/holy2010/2300287