Page 1 of 1
Table 'performance_schema.SESSION_VARIABLES' doesn't exist
Posted: Fri 26 Feb 2016 16:55
by leokwan
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.
Re: Table 'performance_schema.SESSION_VARIABLES' doesn't exist
Posted: Fri 26 Feb 2016 17:07
by ChrisBlackwell
I have exactly the same issue.
MySQL 5.7 on Linux, can't connect.
Re: Table 'performance_schema.SESSION_VARIABLES' doesn't exist
Posted: Sat 27 Feb 2016 18:12
by Kash.freelancer
The same for me too.Server Ubuntu 15.10 mysql 5.7, authentication with ssh key file
Re: Table 'performance_schema.SESSION_VARIABLES' doesn't exist
Posted: Mon 29 Feb 2016 09:44
by .jp
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.
Re: Table 'performance_schema.SESSION_VARIABLES' doesn't exist
Posted: Mon 29 Feb 2016 09:58
by .jp
As a workaround you can change lower_case_table_names variable from 0 to 1.
Re: Table 'performance_schema.SESSION_VARIABLES' doesn't exist
Posted: Mon 29 Feb 2016 13:42
by .jp
Hi!
The fix is available in dbForge Studio v7.0.49. Please update the tool.
Best Regards.