This is a pretty quick post on connecting to Azure Database for MySQL with MySQL Workbench
Download MySQL Workbench
MySQL Workbench can be downloaded from here
Add your IP to white list
Select your Azure Database for MySQL Server and click on Connection Security, then click Add My IP and Save
Set up Connection
Next we need to open MySQL Workbench and copy the connection information from Azure.
- Click on the + to add a new connection.
- Click Store in Vault and enter your password
- Copy the Server name
- Copy the username
- Click OK
Now I created a scheme called test in MySQL Workbench and confirm it is seen in Azure
Note that Azure Database for MySQL is still in Preview mode, this does mean its half price, but might not be production ready.