Databases Reference
In-Depth Information
Figure 2-10. Specifying the server options during the Windows installation
Select a new root user password (there isn't one by default), and then follow the
prompts until the installation process is completed. Unless you know what you're do-
ing, don't select the option to enable root access from remote machines. Also, don't
select the option to create an anonymous account; we'll discuss anonymous accounts
and the security problems associated with them in Chapter 9.
You may find that the installation program fails to configure the service under Vista
(you'll see an error message like “Could not connect to the Service Control Man-
ager”). If this happens, click the Back button twice to return to the options dialog box,
and then uncheck the “Install as a Windows Service” checkbox. Continue the instal-
lation process from this point.
You can run the configuration program again at any time by selecting the MySQL Server
Instance Config Wizard entry from the MySQL Server 5.0 section of the MySQL sub-
menu of the Windows Start menu.
Starting and stopping MySQL as a service
If the installation process successfully configures MySQL as a Windows service, you
can use the Windows Services window at any time to check and control the server. On
Windows XP, select the Performance and Maintenance entry from the Control Panel,
and then choose Administrative Tools. If you have Classic View enabled, you can
choose Administrative Tools directly from the Control Panel. Figure 2-11 shows the
Windows Services window.
