Datasheet

6. To shut down the MySQL service, type
C:\>c:\mysql\bin\mysqladmin -u root shutdown
It’s time to configure your system to improve security, set up some user permissions, and alter your set-
tings according to your preferences.
Configuring Your Installation
Before you configure any of your settings, start the MySQL service again.
1. Enter the following:
c:\>c:\mysql\bin\mysql mysql -u root
Now your screen should look like Figure 1-6.
Figure 1-6
2. Next, see what database tables have been set up by default. Type the following:
mysql> show databases;
You should see the two existing databases, mysql and test, as shown in Figure 1-7.
Figure 1-7
19
Configuring Your Installation
04_579665 ch01.qxd 12/30/04 8:09 PM Page 19