Helping you navigate to the graphical path MySQL GUI Tools

DocumentMySQL 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. Through the project's official website (http://dev.mysql.com/downloads/gui-tools/5.0.html), you can download its pre-compiled 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.

　　
Figure 1 MySQL Query Browser Main Interface

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.

• 2 pages in total:
• Previous Page
• 1
• 2
• Next Page