Databases Reference
In-Depth Information
Figure 3-1. The MySQL Administrator graphical MySQL administration tool
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 adminis-
tration 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 topic, 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.
Exercises
1. What do we mean when we say that MySQL has a client-server architecture?
2. Use the monitor help to look up information on the
SELECT
statement. (We'll dis-
cuss
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?
4. What do the monitor
user
,
password
, and
database
options do?
