表‘performance_schema.session_variables‘不存在

本文翻译自：Table 'performance_schema.session_variables' doesn't exist

After upgrading MySQL to 5.7.8-rc and loging to server I got error: 将MySQL升级到5.7.8-rc并登录到服务器后出现错误：

Table 'performance_schema.session_variables' doesn't exist

I can't find any solution for this. 我找不到任何解决方案。 Can you help ? 你能帮我吗 ？

---

#1楼

参考：https://stackoom.com/question/2A8DH/表-performance-schema-session-variables-不存在

---

#2楼

I was able to log on to the mysql server after running the command @robregonm suggested: 运行命令@robregonm建议后，我能够登录到mysql服务器：

mysql_upgrade -u root -p --force

A MySQL server restart is required. 需要重启MySQL服务器。

---

#3楼

The mysql_upgrade worked for me as well: mysql_upgrade也适用于我：

# mysql_upgrade -u root -p --force
# systemctl restart mysqld

Regards, MSz. 问候，MSz。

---

#4楼

mysql -u app -p
mysql> set @@global.show_compatibility_56=ON;

as per http://bugs.mysql.com/bug.php?id=78159 worked for me. 根据http://bugs.mysql.com/bug.php?id=78159为我工作。

---

#5楼

As sixty4bit question, if your mysql root user looks to be misconfigured, try to install the configurator extension from mysql official source: 作为sixty4bit问题，如果您的mysql root用户看起来配置错误，请尝试从mysql官方源安装配置器扩展：

https://dev.mysql.com/downloads/repo/apt/ https://dev.mysql.com/downloads/repo/apt/

It will help you to set up a new root user password. 它将帮助您设置新的root用户密码。

Make sure to update your repository (debian/ubuntu) : 确保更新您的存储库（debian / ubuntu）：

apt-get update

---

#6楼

sometimes mysql_upgrade -u root -p --force is not realy enough, 有时mysql_upgrade -u root -p --force不够mysql_upgrade -u root -p --force ，

please refer to this question : Table 'performance_schema.session_variables' doesn't exist 请参考这个问题： 表'performance_schema.session_variables'不存在

according to it: 根据它：

1. open cmd 打开cmd
2. cd [installation_path]\\eds-binaries\\dbserver\\mysql5711x86x160420141510\\bin
3. mysql_upgrade -u root -p --force