Create a MySQL service on azure

Azure, like all cloud services, also provides a MySQL database, called MySQL db on Azure in Azure. Let's join together to create a MySQL database on Azure.

In new--Data services, MYSQL database on Azure Select, quickly create, and fill in the response information of the databases.

650) this.width=650; "Src=" Http://upload-images.jianshu.io/upload_images/3899493-bb74a73a0bdad557.png?imageMogr2 /auto-orient/strip%7cimageview2/2/w/1240 "class=" Imagebubble-image "style=" height:auto;vertical-align:middle; border:0px; "alt=" 1240 "/>

1.png

Note: The name can only be in full lowercase.

Once created, you can see the database's response information in the dashboard.

650) this.width=650; "Src=" Http://upload-images.jianshu.io/upload_images/3899493-977a254d126c20b6.png?imageMogr2 /auto-orient/strip%7cimageview2/2/w/1240 "class=" Imagebubble-image "style=" height:auto;vertical-align:middle; border:0px; "alt=" 1240 "/>

2.png

If you want, you can add the required account in the Account tab, the account format is Databasename%username, and you can assign permissions.

In the database configuration, add your own IP address to ensure that it is not filtered by Azure. Some students do not join the whitelist will be unable to connect problems.

650) this.width=650; "Src=" Http://upload-images.jianshu.io/upload_images/3899493-c914035e1511bb52.png?imageMogr2 /auto-orient/strip%7cimageview2/2/w/1240 "class=" Imagebubble-image "style=" height:auto;vertical-align:middle; border:0px; "alt=" 1240 "/>

6.png

Later, we use Mysqlworkbench to connect.

650) this.width=650; "Src=" Http://upload-images.jianshu.io/upload_images/3899493-c0343265d8e94421.png?imageMogr2 /auto-orient/strip%7cimageview2/2/w/1240 "class=" Imagebubble-image "style=" height:auto;vertical-align:middle; border:0px; "alt=" 1240 "/>

3.png

Note: Such a direct connection is not connected. Azure MySQL requires an SSL connection.

Download the certificate to Azure Help Center first.
Make SSL settings on the Mysqlworkbench. and fill in the "SSL Cipher" column Aes256-sha

650) this.width=650; "Src=" Http://upload-images.jianshu.io/upload_images/3899493-5fa592e3b5f99b36.png?imageMogr2 /auto-orient/strip%7cimageview2/2/w/1240 "class=" Imagebubble-image "style=" height:auto;vertical-align:middle; border:0px; "alt=" 1240 "/>

4.png

After the test, you are ready to connect.

650) this.width=650; "Src=" Http://upload-images.jianshu.io/upload_images/3899493-8ac10adb63f7a8dc.png?imageMogr2 /auto-orient/strip%7cimageview2/2/w/1240 "class=" Imagebubble-image "style=" height:auto;vertical-align:middle; border:0px; "alt=" 1240 "/>

5.png

Create a MySQL service on azure