mysql - native 表 'performance_schema' .'???' 结构错误

Question

我得到以下信息:

Native table 'performance_schema'.'file_instances' has the wrong structure
Native table 'performance_schema'.'cond_instances' has the wrong structure
Native table 'performance_schema'.'rwlock_instances' has the wrong structure
Native table 'performance_schema'.'mutex_instances' has the wrong structure
...

然后继续当我重新启动 MySql 时会出现这些错误。好像导致MySql Administrator变得不稳定，我得到了很多:

"MySQL server has gone away"

Answer 1

在shell中尝试以下命令(这里的root用户是mysql root用户，不是系统root)

sudo mysql_upgrade -u root -p

sudo service mysql restart

确保在运行后重新启动 mysql(所有功劳归于评论中的@Mikepote。)