Connect Azure MySQL with Workbench to query a database

To connect to Azure MySQL Server by using MySQL Workbench, perform the following steps:

  • To avoid below error.

Add you local IP address to give access to connect MySQL with your local workbench.

  • Start MySQL Workbench on your computer.
  • On the Welcome page, select Connect to Database.
  • In the Connect to Database dialog box, enter the following information on the Parameters
  • Select Store in Vault, and enter the administrator password specified when the server was created
  • Select OK to create the connection. If the connection is successful, the query editor will open.