Connecting to your Azure Database for MySQL Flexible Server allows you to manage your databases, run queries, and interact with your data using various tools and applications. The process typically involves obtaining your server credentials, configuring network access, and using a compatible MySQL client.
Prerequisites for Connecting
Before you can connect, ensure you have the following information and configurations ready:
- Server Name: The full name of your Azure Database for MySQL Flexible Server (e.g.,
mydemoserver.mysql.database.azure.com). You can find this in the server's overview page in the Azure portal. - Admin User Name: The administrator username you specified during server creation (e.g.,
myadmin). - Password: The password for the admin user.
- Networking Configuration: Your server's networking setup (Public Access or Private Access/VNet Integration) determines how you can connect.
Common Connection Methods
You can connect to your MySQL Flexible Server using several methods:
- Command-Line Clients:
mysqlcommand-line tool (installed with MySQL or MySQL Shell).- Azure Cloud Shell.
- Graphical Tools:
- MySQL Workbench.
- Azure Data Studio (with MySQL extension).
- DBeaver.
- TablePlus.
- phpMyAdmin.
- Application Connections:
- Using connectors/drivers for your preferred programming language (e.g., PHP, Python, Java, .NET).
Step-by-Step Connection with a Client Tool
Connecting using a graphical tool like MySQL Workbench or Azure Data Studio is a common approach. The general steps are as follows:
- Obtain Connection Details: Get your Server Name, Admin User Name, and Password from the Azure portal.
- Configure Networking:
- Public Access: Add your client's IP address (or a range) to the server's firewall rules in the Azure portal.
- Private Access (VNet Integration): Ensure your client is within the same virtual network or has connectivity to the VNet where the MySQL server is integrated.
- Open Your Client Tool: Launch your preferred MySQL client application (e.g., MySQL Workbench).
- Create a New Connection: Find the option to add a new connection.
- Enter Connection Details:
- Hostname/Server Name: Enter the Server Name copied from the Azure portal.
- Port: Use the standard MySQL port, which is
3306. - Username: Enter the Admin User Name.
- Password: You will typically be prompted for this when attempting to connect or test the connection.
- Test the Connection: Most client tools offer a "Test Connection" button to verify the details before establishing the connection. As seen in the reference, clicking "test connection" will often prompt you to enter your password to complete the verification.
- Connect: If the test is successful, save the connection details and connect to the server.
Example: Connecting via MySQL Workbench
Here's a simplified view of the connection parameters in a typical client like MySQL Workbench:
| Setting | Value |
|---|---|
| Connection Name | (e.g., My Azure MySQL Flexible Server) |
| Connection Method | Standard TCP/IP |
| Hostname | mydemoserver.mysql.database.azure.com |
| Port | 3306 |
| Username | myadmin |
| Password | (Click Store in Vault or enter when prompted) |
Once you enter these details, click "Test Connection". You may be prompted to enter your password at this point. If the test succeeds, you can then click "OK" or "Connect" to establish the connection and start querying your database.
Networking Considerations
- Public Access: Simple for quick connections but requires managing IP-based firewall rules.
- Private Access (VNet Integration): Recommended for enhanced security, connecting from within a VNet, or connecting from on-premises via VPN or ExpressRoute. It requires no public IP address exposure.
Ensure your chosen networking method is configured correctly in the Azure portal to allow connections from your client.
Connecting to your Azure Database for MySQL Flexible Server is straightforward once you have the necessary details and have configured network access appropriately.
