Using the MySQL workbench
MySQL has a very nice GUI that we can download for free. It is named the MySQL Workbench.
In this recipe, we will successfully install this workbench and then use it to run SQL queries against the GuiDB we created in the previous recipes, Configuring the MySQL database connection, Designing the Python GUI database and so on.
Getting ready
In order to use this recipe, you will need the MySQL database we developed in the previous recipes. You will also need a running MySQL server.
How to do it…
We can download the MySQL Workbench from the official MySQL website:
Note
The MySQL Workbench is a GUI in itself, very similar to the one we developed in the previous recipes. It does come with some additional features that are specific to working with MySQL.
When you installed MySQL, if you had the required components already installed on your PC, you might have MySQL Workbench already installed. If you do not have the Workbench installed, here are the steps to install the MySQL Workbench...