Table 'performance_schema.SESSION_VARIABLES' doesn't exist

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
leokwan
Posts: 1
Joined: Fri 26 Feb 2016 16:53

Table 'performance_schema.SESSION_VARIABLES' doesn't exist

Post by leokwan » Fri 26 Feb 2016 16:55

When I try to connect to Mysql 5.7 with 7.0 version, I will get this error. No matter what show_compatibility_56 setting is.

"Table 'performance_schema.SESSION_VARIABLES' doesn't exist"

I can see performance_schema.session_variables table, but the table name is in lower case, and I am running on Linux and tables' name is case sensitive.

ChrisBlackwell
Posts: 1
Joined: Fri 26 Feb 2016 17:05

Re: Table 'performance_schema.SESSION_VARIABLES' doesn't exist

Post by ChrisBlackwell » Fri 26 Feb 2016 17:07

I have exactly the same issue.
MySQL 5.7 on Linux, can't connect.

Kash.freelancer
Posts: 1
Joined: Sat 27 Feb 2016 18:06

Re: Table 'performance_schema.SESSION_VARIABLES' doesn't exist

Post by Kash.freelancer » Sat 27 Feb 2016 18:12

The same for me too.Server Ubuntu 15.10 mysql 5.7, authentication with ssh key file

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Table 'performance_schema.SESSION_VARIABLES' doesn't exist

Post by .jp » Mon 29 Feb 2016 09:44

Hello.

Thanks for the post.
We're aware of the problem and it's been already fixed.
A new build will be available ASAP.

Best Regards.

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Table 'performance_schema.SESSION_VARIABLES' doesn't exist

Post by .jp » Mon 29 Feb 2016 09:58

As a workaround you can change lower_case_table_names variable from 0 to 1.

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Table 'performance_schema.SESSION_VARIABLES' doesn't exist

Post by .jp » Mon 29 Feb 2016 13:42

Hi!

The fix is available in dbForge Studio v7.0.49. Please update the tool.

Best Regards.

Post Reply