The graphical path to the MySQL mystery kingdom

MySQL GUI Tools is a set of graphical desktop utility tools that you can use to manage MySQL servers. The kit includes three tools: MySQL Query Browser, MySQL administrator, and MySQL migration Assistant (only Windows platforms). In this article, we'll look at the first two tools and see how they help us manage the MySQL database without using the command line.

The MySQL GUI Tools installation is very simple, on Ubuntu, Debian or Fedora Linux, you can install it through the Package manager, in Ubuntu and Debian, the package name is mysql-admin; On Fedora is mysql-gui-tools. Through the project's official website (http://dev.mysql.com/downloads/gui-tools/5.0.html), you can download its pre-compilation bytecode and source code installation package.

After the installation is complete, you can see a new menu entry in GNOME's Applications-> programming menu. You can also launch the tool from the Terminal window, which commands Mysql-query-browser and mysql-administrator. Both MySQL Query Browser and MySQL administrator can support the management of multiple MySQL servers at the same time. Let's take a look at the two tools.

One, MySQL Query Browser

When you start the MySQL Query Browser, a dialog box pops up asking you to fill in some basic information about the MySQL server you want to connect to, such as the MySQL server's IP address, port number, username, and password. Once the connection is created, you will see a workspace window where you can create a new database, add tables, type and query data, export query results, and run SQL scripts.

Figure 1, MySQL Query Browser main interface

This query browser window is divided into three different areas. The sidebar on the right contains a couple of tabs, from where you can view databases, bookmarks, and history, as well as a reference section for SQL syntax. At the top of the query window, you can enter the SQL code.

To create a new MySQL database, click on the Schemata tab, and then right-click in the sidebar, click Create New Database from the pop-up menu (schemata), and fill in the name of the database where we use Mysqlguidemo. Refreshing the database, we will be able to see the newly created database from the sidebar.

There are two ways for a user to set up a database as the default database: Modify the default database from file->-> Select the database, or right-click the database, and then select Set as the default database. The default database appears in bold form in the sidebar.

To add a table to the database, it's also very simple, taking the database we created above as an example, right click on the Mysqlguidemo database we just created, click Create New table, open the table editor, and through it you can enter the details of the new table you want to create. After adding the information, click Apply Change (apply Changes) to perform the creation of the table, followed by a Table Action dialog box, where you can see the SQL statements that the program will execute against your database, and click the Execute button if there is no problem. When the table is added, you will see a tree-shaped list displayed in the sidebar, as shown in the following figure.

Figure 2, add table