Learning Mysql

Select anew 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 doing, 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 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 Manager. 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 installation process from this point.
You can run the configuration program again at anytime 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 anytime 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.
Figure 2-10. Specifying the server options during the Windows installation
Installing Under Windows | 53

Under Vista, open the Control Panel, and select the System and Maintenance entry.
From here, select the Administrative Tools and then the Services entry. Windows may prompt you for authorization—click Continue.
Scroll down the list of services till you see an entry for MySQL, and select it. The installation process sets the service status to be Automatic—that is, the server is started automatically every time Windows is booted. If you’d prefer to start and stop the server manually, you can set the service status to Manual. You can also start and stop the server by clicking the Start or Stop link on the left of the Services window, or by opening a command-prompt window and typing:
C:\> net start mysql
or:
C:\> net stop mysql
Figure 2-11. The Windows services window

Download 4.24 Mb.

Share with your friends: