Getting Started with MySQL on Azure

Here is a quick set of screenshots that will help you get started with MySQL on Azure!

1) Search for Azure Database for MySQL in the Portal.

2) Choosing the correct service deployment options: Flexible server gives you a standalone / HA aware solution by itself, the second option is used for deploying a WordPress Site + MySQL Flexible server. I have chosen Flexible Server

3) Choose your subscription and Resource group now and provide the server details in the following screenshots.

Note for the SKU I have chosen, requires a higher compute tier, hence this message. I have chosen not to use HA in this example.

Finally,

Once the creation is done, you may user the following in CloudShell to connect to your db server

Code to connect:
mysql -h <yourservername>.mysql.database.azure.com -u <username> -p        

Next run the following commands in the MySQL shell prompt:

SELECT VERSION(); to get the version

SHOW DATABASES; to get the list of databases

The results can be seen below

Congrats!! You have just created your very first MySQL Database server on Azure!

Stay tuned for more tutorials...

#AzureDatabaseforMySQL #FlexibleServer #MySQL #MicrosoftAzure #Azure #MySQL #AzureSQL