Create and link a MySQL database on Azure

This QuickStart describes how to create and connect to a MySQL database using the Azure portal. All of the actions completed in this tutorial are eligible for the 1-dollar trial condition.

Before you begin
If you don't have an Azure account, you can request a $1 trial account

Step 1: Create MySQL Database on Azure
1. Log in to the Azure portal and click on "+ new", "Databases", "MySQL Database on Azure".
2. Enter the required parameters and click "Set up First database" to create a new database on the database server that will be created.

3. Click "Configure Performance" and select "MS1" Performance layer.
4. Wait a few minutes, the database is created, then click "Connect Security", "+ Add client IP", "save" to add the current client to the whitelist.

5. Open your MySQL server and click on "Database", "Your Database".

6. Click "Connection string" to view and copy the required connection string, which will be used in the next steps.

Step 2: Download and install the MySQL client
1. To download the MySQL Workbench page, download and install the latest version of MySQL Workbench.

2. Select "Complete" for full installation.
Step 3: Connect to the MySQL database
1. Open MySQL workbrench, click "Database", "Manage Connections ...".

2. Click "New" to enter a recognizable name and the connection information obtained in step 1.

3. Click "Store in Vault ..." to enter the corresponding password for the database user.

4. Click "Test Connection" to see if your connection information is available and the following session box will appear if the connection is successful.

5. Click "Database", "Connect to Database ...", select the connection you just saved, then click "OK".
6. Wait a few seconds for the data in the database to be managed through MySQL Workbench.

More steps Welcome Click to view

Interested friends are welcome to communicate

A research institute graduate student [email protected]

Create and link a MySQL database on Azure