Introduction to MySQL GUI tools

From: http://database.ctocio.com.cn/422/8919922.shtml

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 ).

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 SQLCode.

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 the information is added, click Apply changes to create the table. A table operation dialog box is displayed.ProgramThe SQL statement is executed for your database. If no problem exists, 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.