How to connect azure sql server connection from mysql workbench on Macbook

Question

I have azure subscription 1 and When i am trying to connect azure sql server from mysql workbench I am unable to connect

Answer 1

Since I have never used MySQL Workbench, I may be misunderstanding something, but I am under the impression that MySQL Workbench is for running queries etc against MySQL. But you are saying that you want to connect to Azure SQL Server, and which is a completely different thing. SQL Server != MySQL.

If you want to connect to Azure SQL Database, Azure SQL Managed Instance or SQL Server running in an Azure Virtual Machine, the tool you would use is Azure Data Studio. Azure Data Studio runs on multiple platforms, including MacBook. While Azure Data Studio's main focus is SQL Server, there are also extensions for connection to a few other DBMS, including MySQL.

Answer 2

in addition to Erland you cannot use workbench as mssql client but you can only connect mssql by using workbench for migration

https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-connection.html

you need to go with Erland proposed tools to connect and use mssql

Answer 3

Hi Kowluru, Guru Bhargava Reddy,

Welcome to Microsoft Q&A forum.

As I understand, you want to open Azure Database for MYSQL using Workbench on Mac and could not do so.

Let us know if your ask is different.

Please follow tutorial here: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-workbench

and try to connect.

Also download workbench from here: https://dev.mysql.com/downloads/workbench/

Please share error message and the steps you have followed so that we can assist.

Just checking in to see if the provided suggestion by Erland helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

Thanks