Error on connecting to Azure Database for MySQL Server

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
SchmittDotNet
Posts: 7
Joined: Mon 15 Jun 2020 15:41

Error on connecting to Azure Database for MySQL Server

Post by SchmittDotNet » 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.

alexa

Re: Error on connecting to Azure Database for MySQL Server

Post by alexa » Tue 16 Jun 2020 09:52

We were not able to reproduce it.
Could you please double-check if the server version is indeed 5.7.29 and provide us a screenshot of the error?

SchmittDotNet
Posts: 7
Joined: Mon 15 Jun 2020 15:41

Re: Error on connecting to Azure Database for MySQL Server

Post by SchmittDotNet » Tue 16 Jun 2020 16:19

Thanks for the response.
Server version is 5.7.29.
Actually connection succeeded now. I typed in the database name into the connection dialogue instead of letting him enumerating databases. But not totally sure whether this was helping.

alexa

Re: Error on connecting to Azure Database for MySQL Server

Post by alexa » Wed 17 Jun 2020 07:19

Thank you for updating us on this issue.

Please let us know if it happens again.

Post Reply