Learning MySQL

Graphical Clients

Before we end this chapter, let’s have a quick look at two graphical clients that you can use in place of the monitor.

The MySQL Administrator program is a graphical tool that you can download as part of the MySQL GUI Tools Bundle from the MySQL AB downloads page at http://dev.mysql.com/downloads. This program allows you to perform most database administration from within a graphical environment, as shown in Figure 3-1.

Figure 3-1. The MySQL Administrator graphical MySQL administration tool

The MySQL Query Browser program is also available for download from the same web page. This allows you to run SQL queries from within a graphical environment, and view the results. A sample query is shown in Figure 3-2.

Figure 3-2. The MySQL Query Browser graphical MySQL client

Together, these tools replace an older program known as the MySQL Control Center mysqlcc. In this book, we focus on doing things using the monitor; once you understand the way MySQL works, you’ll find it easy to use other clients such as these.