Datasheet

3. Now see what tables are there. Type the following:
mysql> show tables;
You should see what is depicted in Figure 1-8.
Figure 1-8
4. By default, MySQL on Windows sets up all users with all privileges. For this reason, you want
to focus on the
user table for a moment. If you would like to see all the privileges that can be
assigned, you can type the following:
mysql> SHOW COLUMNS FROM user FROM mysql;
You only want to look at what users are already there, so type the following:
mysql> SELECT user, host FROM user;
You should see what is depicted in Figure 1-9.
Figure 1-9
20
Chapter 1
04_579665 ch01.qxd 12/30/04 8:09 PM Page 20