Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to create MYSQL on Azure, the contents of the article are carefully selected and edited by the author, with a certain pertinence, for your reference significance is still relatively great, the following with the author to understand how to create MYSQL on the Azure bar.

Select New-> data Service, Mysql database on azure, create it quickly, and fill in the database response information.

1.png

Note: the name can only be in lowercase.

After the creation is successful, you can see the response information of the database in the dashboard.

2.png

If necessary, you can add the desired account to the account Tab, the account format is databasename%username, and permissions can be assigned.

In the database configuration, please add your own IP address to ensure that it will not be filtered by Azure. Some students will be unable to connect because they are not added to the whitelist.

6.png

Later, we use mysqlworkbench to connect.

3.png

Note: it is impossible to connect directly like this. MYSQL for Azure requires a SSL connection.

First go to the Azure help Center to download the certificate.

Set up the SSL on Mysqlworkbench. And fill in AES256-SHA in the column "SSL Cipher"

4.png

After that, it is tested and can be connected.

5.png

After reading the above about how to create MYSQL on Azure, many readers must have some understanding. If you need more industry knowledge and information, you can continue to follow our industry information column.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.