Connecting to Azure Database for MySQL with MySQL Workbench

Azure Database for MySQL server
Azure Database for MySQL server

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

Add IP to Azure Database for MySQL server Whitelist

Add IP to Azure Database for MySQL server Whitelist

Set up Connection

Next we need to open MySQL Workbench and copy the connection information from Azure.

  1. Click on the + to add a new connection.
  2. Click Store in Vault and enter your password
  3. Copy the Server name
  4. Copy the username
  5. Click OK
Set up Azure Database for MySQL server connection information

Set up Azure Database for MySQL server connection information

Test

Now I created a scheme called test in MySQL Workbench and confirm it is seen in Azure

Validate connection to Azure Database for MySQL Server

Validate connection to Azure Database for MySQL Server

Note that Azure Database for MySQL is still in Preview mode, this does mean its half price, but might not be production ready.

Tags