Using DBeaver to connect to Azure Database for MySQL - Flexible Server
Published Nov 27 2023 11:31 AM 3,720 Views
Microsoft

If you’re running an instance of Azure Database for MySQL - Flexible Server, you know how important it is to have a convenient way to connect to and work with the database. That’s where the DBeaver's Ultimate and Team Edition come in. 

 

You can choose from either of the solutions to manage your MySQL databases in Azure:  

  • DBeaver UltimateMultifunctional database tool with native AWS, Azure, and Google Cloud support in a desktop app. 
  • Team Edition: A highly secure, single data solution for all teams to manage data privately in a web version and desktop app. 

If you don’t have DBeaver installed, you can download it from here 

 

In this blog post, I'll provide step-by-step instructions for connecting with DBeaver Ultimatebut the steps are similar for Team Edition as well.

 

Note: DBeaver Ultimate and Team Edition are commercial versions of DBeaver offerings; you can view the related pricing details here 

 

Connect using DBeaver Ultimate

Before getting started, in the Azure portal, locate and make a note of the connection information, such as server name, username, and password for the Azure Database for MySQL flexible server. Then, to connect to your MySQL – Flexible Server database, navigate through the DBeaver connection wizard, performing the following steps.  

 

  1. In the application, at the top of the application toolbar, select New Database Connection, in the list of database drivers, select MySQL, and then select Next. 

 

mk_sunitha_0-1700635301842.png

       2. In the Connection Settings dialog box, on the Main tab, specify the Server Host, Port, Username, and Password. 

mk_sunitha_1-1700635301845.png

 

 
 3. If your configuration requires using an SSL certificate, on the SSL tab, select the Use SSL check box, and then specify details for all required fields. Note that for enhanced security, Microsoft recommends enabling the Require SSL setting whenever possible. 


 
mk_sunitha_2-1700635301846.png

 

4. After you configure all the settings, select Test Connection. If the connection can be established, a window will appear with the result and driver information. 

    

4. Finally, to create the connection, select Finish.

 

The new connection appears in the navigation tree, and you can start creating new databases, loading data, and running queries.  

mk_sunitha_3-1700635301847.png

 

Connect using Cloud Explorer 

You can also use DBeaver’s Cloud Explorer to set up cloud access one time, and then easily browse, connect, and manage your cloud databases. For more information about connecting to Azure Database for MySQL - Flexible Server by using Cloud Explorer, on DBeaver's blog, see the related post, How to connect to MySQL in Microsoft Azure with DBeaver 

 

Conclusion 

This post has provided details about how to use DBeaver to connect to and manage Azure Database for MySQL flexible servers. DBeaver is a powerful database tool with features for user management and team collaboration, providing a single solution for managing all of your servers with centralized authentication, including Active Directory. To learn even more about DBeaver, see their product documentation

 

If you have any feedback or questions about the information provided above, please leave a comment below or email us at AskAzureDBforMySQL@service.microsoft.com.

 

 

Co-Authors
Version history
Last update:
‎Nov 27 2023 11:29 AM
Updated by: