In this blog post we are going to create Azure MySQL database.
Login to your Azure portal and click on Create a resource.
If you don't have Azure account create it as I described here.
Find Database then Azure Database for MySQL and click on it
Choose existing Resource Group or Create a new one
Then provide server details, remember all this, you are going to use it later.
Click on Configure Server and choose Basic tier with default configuration
And Click on OK
Click on Review and Create.
Now download MySQL workbench from https://dev.mysql.com/downloads/workbench/
And connect to database by clicking on Database -> Connect to Database...
Provide values we created when we created Azure MySQL server
Hostaname you find in Azure Portal -> click on Azure Database for MySQL server resource and in the overview blade you find Server name. It looks like servername.mysql.database.azure.com. For Port just use the default value.
Username has a strange format: admin [email protected] name and Password you don't have to define now.
If you get error message like this
Open your Azure Database for MySQL server resource and find Setting then Connection security
Click on Add client IP and Enforce SSL connection should be DISABLED. Save everything and try again.
Now connect to database using this new connection.
Now we have to create a database. Click on database icon
Provide the name
Click on Apply
Click on Apply once more.
Congratulations you just created your first MySQL database.