Azure MySQL as a Service is in Preview
On today’s Micrsoft Build conference, the Azure team revealed and released a new feature to the Azure Preview Portal. Now, Azure provides managed MySQL databases.
Where can I find the new feature?
To test the new MySQL service right now, just hit the Preview Portal, by adding the “preview” subdomain in front of the “normal” portal url.
Then type MySQL in the search bar at the top of the page and hit enter.
Create a new MySQL database service
As time of writing this post, there is only the “Basic” tier available. In the smallest setup, it will cost 15 € per month, for 50 compute units and 50 GB of storage.
On the pricing page you can see the prices for the Standard tier as well.
Create and manage databases
From this point you can manage your database service via the MySQL Workbench or via the command line.
But first you have to allow connections to your new service, hit “Connection security” on the Azure Portal and then click on “Add My IP”. This will automatically create the Firewall rules for your actual connection.
The MySQL Workbench is very self explaining, so just jump in and use the command line to connect to our new database server. For this I made use of the Windows 10 Linux Bash and I entered the following code, just replace the server address and the username of your admin.
|# install mysql client|
|sudo apt install mysql-client-core-5.7|
|mysql -h ztiromsql.mysql.database.azure.com -u mysqlserveradmin@ztiromsql -p|
|create database ztirom;|
This will first install the MySQL client, next it connects to the server and then creates a new database.
That will bring up our fist MySQL database on Azure.