README.md

Create an Azure Database for MySQL

Prerequisites

This example assumes you have previously completed the following example:

1. Create an Azure Resource Group

Create the Azure Database for MySQL

To create the Azure Database for MySQL setup the following environment variables:

  export MYSQL_NAME=joaz-mysql-$RANDOM
  export MYSQL_USERNAME=mysql
  export MYSQL_PASSWORD=p#ssw0rd-$RANDOM

And then create the MySQL database using the command line below:

  az mysql server create \
    --admin-user $MYSQL_USERNAME \
    --admin-password $MYSQL_PASSWORD \
    --name $MYSQL_NAME \
    --resource-group $RESOURCE_GROUP \
    --sku B_Gen5_1 \
    --ssl-enforcement Disabled

Cleanup

Do NOT forget to remove the resources once you are done running the example.

Next steps

• Open MySQL server firewall to your IP address

Reference documentation

• Manage Azure Database for MySQL servers
• Azure Database for MySQL Documentation
• Migrate to Azure Database for MySQL
• Minimal downtime migration
• Query data using Java

4m