Table 'performance_schema.session_variables' doesn't exist

mysql upgrade
Taz picture Taz · Aug 12, 2015 · Viewed 159.2k times · Source

After upgrading MySQL to 5.7.8-rc and loging to server I got error:

Table 'performance_schema.session_variables' doesn't exist

I can't find any solution for this. Can you help ?

Answer

Mihai Caracostea picture Mihai Caracostea · Oct 21, 2015

I was able to log on to the mysql server after running the command @robregonm suggested:

mysql_upgrade -u root -p --force

A MySQL server restart is required.

Related questions

How can Upgrade MySQL 5.5.40 to MySQL 5.7

How can I Upgrade MySQL version Current MySQL Version: 5.5.40 Target MySQL Version: MySQL 5.7 OS: CentOS release 6.5 (Final)

Read More
phpMyAdmin - Error You should upgrade to MySQL 5.5.0 or later

I installed phpMyAdmin-4.2.9.1-english on a Centos 6.5 platform. 2.6.32-431.23.3.el6.x86_64 #1 SMP Thu Jul 31 17:20:51 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux When I login I get the following screen: phpMyAdmin - Error You should upgrade to MySQL 5.5.0 or later. I am …

Read More
How to update mysql version in xampp (error with innodb_additional_mem_pool_size)

I'm trying to upgrade mysql in xamp. I'm using laravel which requires mariaDB v10.2.2. So I downloaded the latest msi package from the mariaDB website. Now I followed following points to install the same: Install MySQL to C:\TEMP. Make …

Read More