Quickly create a MySQL db instance in the cloud in one minute

This tutorial will help you learn how to use the Azure management portal to quickly create, connect, and configure a MySQL database on Azure. After completing this tutorial, you will have a sample MySQL database server on Azure and learn how to perform basic administrative tasks using the management portal.

Step one: Log into the Azure Management portal and create a MySQL server

2. Log in to the Azure Management portal and select MySQL database on Azure in the right navigation bar.

4. Click New at the bottom of the page, and when you click New, a list of what can be created appears on the screen.

5. Click "MySQL database on Azure" and click Quick Create

   Note: Your user name is made up of "server name% User name" or "username @ server name", please be careful to fill in the full user name when you connect to the database.

   Enter the parameters needed to create a new server and click Create. You'll have a new MySQL server in two minutes.

   Note: It is strongly recommended that you place the Azure service in the same region and choose a location that is closest to you.

   Step Two: Configure the firewall

   The first time you have a MySQL database on Azure from your client, you need to configure the firewall to add your client public IP address (or IP address segment) to the whitelist. On the admin portal, click on your instance and then click "Configure" to complete the IP address additions via the following interface.

   By default, your other services on Azure (including VMs on Azure) allow access to your MySQL database, and you no longer have to add IP addresses manually. You can also change this default feature, in "Allowed services", "Windows Azure Services" option "no"

   Step three: Set the backup time

   MySQL database on Azure supports two forms of backup: On-demand backup and daily scheduled backups. You can select your MySQL server and click "Configure" to set the daily backup time. You can select the automatic backup time from the drop-down menu.                          ,         &NB Sp                          ,         &NB Sp                          ,         &NB Sp                          ,         &NB Sp                          ,         &NB Sp                          ,         &NB Sp                            

   Step four: Create a database

   In a MySQL server, users can create multiple databases with no limit on the number, but multiple databases share server resources. You can select the MySQL server, click "Database", click "New" in the lower left corner to create the database.

   Step five: Connect to the database

   You can get the server address by viewing the "dashboard" of the management portal and connect your database on azure to the MySQL database via the application.

   Note:mysql database on Azure support SSL connection, if your app is not in the same Azure datacenter as the MySQL database, we recommend that you connect with SSL to enhance security.

   Step Six: Data migration (optional)

   If you need to migrate the database from somewhere else to the MySQL database on Azure, it is recommended that you complete the migration with the following steps when the volume of data is large. -The first step is to export the data from the current database to a file (for example, with the Mysqldump tool). -The second step is to transfer the database export file to one of your VMS on Azure. You can use your familiar data transmission tools (such as FTP, etc.), you can also use azcopy this tool (with azcopy need to transfer the file to a storage blob, and then to the VM). -Third step, import data from your Azure VM to your MySQL database on Azure. This reduces the likelihood of a migration failure due to disconnection in the middle of the connection.

   Next steps

   By completing the steps above, you have established the MySQL database on Azure and have an understanding of the management portal. Next, you can try other features, such as viewing database usage, database backup and recovery, version upgrade demotion, and so on.

   If you're having trouble with the operation, you can review the management Portal Help Guide, or contact technical support, or ask your question at the MSDN forum.

   Finally, the small series also has an appeal:

   Visit http://market.azure.cn Now

Quickly create a MySQL db instance in the cloud in one minute