Share via

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

Anonymous
2024-08-02T22:11:14.9733333+00:00

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

Azure Database for MySQL
SQL Server | Other

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
    2024-08-03T08:53:09.0133333+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments

  2. SSingh-MSFT 16,461 Reputation points Moderator
    2024-08-06T05:39:03.1333333+00:00

    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

    0 comments No comments

  3. Sedat SALMAN 14,370 Reputation points MVP
    2024-08-04T05:04:53.2466667+00:00

    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

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.