A graphical path to the mysterious MySQL kingdom

MySQL GUI Tools is a set of graphical desktop application Tools that can be used to manage MySQL servers. The tool package includes three tools: MySQL Query Browser, MySQL Administrator, and MySQL Migration Assistant (only supported on Windows platforms ). In this article, we will introduce the first two tools to see how they help us manage MySQL databases without using command lines.

The installation of MySQL GUI Tools is very simple. on Ubuntu, Debian, or Fedora Linux, you can install it through the Package Manager on Ubuntu and Debian, the package name is mysql-admin and mysql-gui-tools on Fedora. On the project's official website (), you can download the pre-compilation bytecode and source code installation package.

After the installation is complete, you can see a new menu entry in the Applications> Programming menu of GNOME. You can also start this tool in the terminal window, with commands mysql-query-browser and mysql-administrator respectively. Both MySQL Query Browser and MySQL Administrator can manage multiple MySQL servers at the same time. Let's take a look at these two tools one by one.

I. MySQL Query Browser

After MySQL Query Browser is started, a dialog box is displayed, asking you to enter some basic information about the MySQL server you want to connect to, such as the IP address, port number, user name, and password of the MySQL server. After 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.

The Query Browser window is divided into three different regions. The sidebar on the right contains several tags. Here you can view the database, bookmarks, and history. It also provides a reference for SQL syntax. In the Query window at the top, you can enter the SQL code.

To Create a New MySQL database, click the Schemata tag, right-click on the sidebar, click Create New Schemata from the pop-up menu, and enter the database name, here we use mysqlguidemo. Refresh the database. We can see the newly created database from the sidebar.

You can set a database as the default database in two ways: choose File> modify default database> select database, or right-click the database and select set as the default database. The default database will appear in bold on the sidebar.

To add a Table to a database, you can use the database we created above as an example. Right-click the mysqlguidemo database we just created, and then click Create New Table ), open the table editor and enter the details of the new table to be created. After adding the information, click Apply Changes to create the table. A table operation dialog box is displayed, here you can see the SQL statement that the program will execute for your database. If there is no problem, click the execute button. When the table is added, you will see a tree list in the sidebar, as shown in.

To modify the table information, right-click the table name and select Edit from the pop-up menu.

In addition, you can use MySQL Query Browser to execute SQL statements. Select File> New Script, or you can use File> open Script to load an existing SQL Script, after the script is loaded, click Execute to call the script. In addition, you can save this SQL script for future use.

To retrieve records from a table, double-click the table name in the sidebar. In the Query window above, you can see the corresponding Query statement, and then click the execute button, A result set is created in the result set label. In the result set, you can easily browse, search, or edit existing records, and add new records. To add a new record or Edit an existing record, click Edit at the bottom of the window. In addition, you can export the result set as CSV, HTML, XML, and Excel files.

Other functions of MySQL Query Browser include history and bookmarks. By using the history function in the sidebar, you can view or re-Execute previous query operations. Using the bookmarks function, you can save existing SQL query statements as bookmarks. The query commands marked as Bookmarks can be viewed on the bookmarks tab on the sidebar.

With table options and advanced settings labels, you can perform many settings, such as the storage engine, Character Set, row format, RAID settings, and many other settings used.

You can create an SQL transaction by using the Start, Commit, and Rollback commands in the menu. In addition, you can add stored procedures and functions to the database.

Ii. MySQL Administrator

Through MySQL Query Browser, we can easily create databases and tables, fill them with data, and write stored procedures and functions. However, as the table size increases, there will be many complex user access situations. You also need a tool to help you easily and efficiently manage MySQL servers.

The command line tool mysqladmin can help us manage MySQL servers. However, MySQL Administrator is a more intuitive and powerful MySQL server management tool. It has an intuitive graphical interface and graphical performance indicator.

Similar to MySQL Query Browser, You need to manually fill in the information of the database to be connected. After logging on, you will get a Summary of the server and client information; here the client is MySQL Administrator.