MySQL Database is a database service that you can run on your local server and also on a cloud platform like Azure and AWS. It is free to download and can be used by both small and big corporate organizations and make use of structured query language (SQL). It has some advanced features and support is always available for any issues. The data in a MySQL database are structured and stored in tables, table is a collection of related data, and it consists of columns and rows. MySQL Workbench is a visual database design tool that you can use to integrate SQL development, administration, database design, creation and maintenance into one integrated development environment (IDE). For related guide on MySQL read these: MySQL Workbench not connecting to localhost: How to fix there is no connection to the MySQL Server, How to reset Mysql Root password, How to create and delete MySQL database, How to access MySQL Server from command Prompt
You can download both MySQL Database and MySQL Workbench from https://dev.mysql.com/downloads and install them.
After installing go ahead and launch the MySQL Workbench.
- Enter a name in the Stored Connection text box.
- Leave the connection method on Standard (TCP/IP)
- To get the Hostname, Username login to your Azure account and click on Azure Database for MySQL and click on the MySQL database you want to connect to.
- Copy the Server name and past in the Hostname text field.
- Copy the Server admin login name and paste in the Username text field.
- Click on the Connection security menu by the left and add your system IP to be Allowed access to Azure services.
- Enter the password to access your database on Azure by clicking on the button Store in Vault
Input your valid password and click OK
If all goes well and you supplied valid credentials then you should be able to connect to your Azure MySQL Database.
On the Query panel type show databases to display all the database that exist.
To start downloading or exporting your database click on Data Export. In the drop down you can select Dump Structure and Data and in the Objects to Export section you can decide to check all.
Select the destination where you want your database to be located locally and the method you want either Export to Dump Project Folder or Export to Self-Contained File.
After all these click on Start Export.
After all these click on Start Export and you will have your MySQL Database locally exported in no time.
I hope you found this blog post on How to use MySQL Workbench to download your MySQL database from Azure to local computer very interesting and helpful. In case you have any questions do not hesitate to ask in the comment section.