Error on connecting to Azure Database for MySQL Server
Posted: Mon 15 Jun 2020 16:14
Hi,
I am using dbForge Studio for MySQL 9.0.304 to connect to Azure Database for MySQL 5.7.29. On Test Connection I get:
The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'
Actually if show_compatibility_56=ON is set the connection is working. But this setting is no option for us.
Any ideas? Thanks in advance for the support.
I am using dbForge Studio for MySQL 9.0.304 to connect to Azure Database for MySQL 5.7.29. On Test Connection I get:
The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'
Actually if show_compatibility_56=ON is set the connection is working. But this setting is no option for us.
Any ideas? Thanks in advance for the support.