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. 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. 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.
Exercises1. What do we mean when we say that MySQL has a client-server architecture. Use the monitor help to lookup information on the
SELECT
statement. (Well discuss SELECT in detail in Chapter 5.)
3. What is the difference between using the monitor in interactive mode and using the monitor in batch mode.
What do the monitor user, password, and database options do?
Figure 3-1. The MySQL Administrator graphical MySQL administration toolExercises | 105
