Windows NT/2000 Startup

On Windows NT, you should have at least service pack 3 to get the right level of TCP/IP support for MySQL.

We recommend that you run the MySQL server as an NT service. The simplest way to install MySQL as a service is to use the winmysqladmin.exe utility that comes with a Windows installation of MySQL. You can use this tool to configure MySQL and install it as a service.

To install MySQL as a service by hand, open up an MS-DOS window and type:

C:\> c:\mysql\bin\mysqld-nt -install

This will create an NT service called MySQL. This service is now available from the Services control panel. To access this, open your control panel and double-click on the Services icon.[1] Figure 2-1 shows the Services control panel from a Windows NT box with MySQL installed as a service.

A Windows NT Services control panel with MySQL installed
Figure 2-1. A Windows NT Services control panel with MySQL installed

Now you can start MySQL by clicking on the Start button. If you would like to change the command-line options for the MySql service, you can type them in the Startup Parameters text box before starting the service. In Figure 2-2, after the service has started, the status shows as Started.

The Started MySQL service
Figure 2-2. The Started MySQL service

To stop the service, click on Stop. You can also start and stop the service from an MS-DOS prompt using the ...

Get Managing & Using MySQL, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.