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.
Error on connecting to Azure Database for MySQL Server
-
- Posts: 7
- Joined: Mon 15 Jun 2020 15:41
Re: Error on connecting to Azure Database for MySQL Server
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?
Could you please double-check if the server version is indeed 5.7.29 and provide us a screenshot of the error?
-
- Posts: 7
- Joined: Mon 15 Jun 2020 15:41
Re: Error on connecting to Azure Database for MySQL Server
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.
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.
Re: Error on connecting to Azure Database for MySQL Server
Thank you for updating us on this issue.
Please let us know if it happens again.
Please let us know if it happens again.