Python HOW: Setting up an Azure MySql Server

Learn how to create an Azure MySQL server and to interact with it using your local Python environment 🕵️

source: author

1 Create 🔨

• Sign into the Azure portal
• Select + Create a resource in the portal
• Search for Azure Database for MySQL Flexible Server 👉 Create
• Fill in the new server details as below 👉Create

Basics

Change the workload type according to your needs but watch out for the costs

Networking ☎️

• Enable Public access so you can connect remotely over allowed IP addresses
• Allow access from other Azure services (e.g., Azure Web App Services)
• Add your current IP address so you can connect remotely from your local machine

Networking configurations

2 Configure

Once the server is provisioned, 👉 Go to resource where you can download the SSL certificate and copy the connection’s details

Download SSL Certificate🔧