"show_compatibility_56" Error

[toaster-loss]

When I try to connect to a normal installation of MySQL 5.7.9 I get the following error:

The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'

I believe I can turn on show_compatibility_56, but I also read that INFORMATION_SCHEMA.GLOBAL_VARIABLES is deprecated and will be removed in a future release. Is there a better way to get dbForge to work with MySQL version 5.7 or higher other than turning this on manually?

[Lucky29]

If you are selecting from information_schema tables in show_compatibility_56=OFF mode, change it to show_compatibility_56=ON

[toaster-loss]

I'm not manually selecting information from that table, dbForge appears to be doing it behind the scenes whenever I open a connection.

[alexa]

This version of the MySQL server is planned to be supported in the next version of dbForge.

In the meanwhile, you could try using the command line interface of dbForge or execute the following for compatibility:

Code: Select all

set @@global.show_compatibility_56=ON; 

Please also see http://dev.mysql.com/doc/refman/5.7/en/ ... ibility_56

[nickweavers]

Any update on when dbForge for MySQL will support this (I'm on 6.3.358)? I understand that show_compatibility_56 is now deprecated.

[.jp]

Hello.
Thanks for the post.
A new version of the dbForge Studio for MySQL with the fix is scheduled to be released next week.
Best Regards.

[nickweavers]

Great news!

Many thanks.

[alexa]

We would like to let you know that dbForge Studio for MySQL, v7.0, where MySQL 5.7 is supported, is available for downloading https://www.devart.com/dbforge/mysql/st ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.

[nickweavers]

I have it installed already:).

Will be trying the 5.7 support soon.

Thanks for a great product.